HELP - A formula or sheet you want to move or copy contains the name ....

Aug 16, 2012
Reaction score

First off thanks for reading,

My problem is I have a master workbook that line managers put all of their staff information into, up to 12 staff. The sheet workbook uses defined name lists ( as we need to govern/analyse the information), in case the line manager wants to populate the information straight onto it. However there is an individual version that the line manager can ask the person to complete as some staff work remotely, which the LM would then paste it into the master workbook. The individual sheet also contains the same wording but a different define name list so that pasting would not cause an issue.

Pasting works fine once, but once the pasting occurs twice the 'A formula or sheet you want to move or copy contains the name' warning appears. We need to find a solution as the click yes is not one over the volume of LM that are using it.

Many thanks


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question