Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm updating a spreadsheet that refers to data in another worksheet =NameofWorksheet for some reason I get #NAME? in some of the cells, even when the actual path is correct.

The only way to overcome the problem is to open up the source spreadsheet and then recalculate the destination spreadsheet. But, if I then close the workbooks; open up just the destination workbook the #NAME? issue comes back.

I've even created a test destination spreadsheet and it doesn't suffer from the #NAME? problem.

Any reason for this? Should I be worried about the integrity of some Sheets?

Any advice greatly appreciated.


share|improve this question
#NAME? in some of the cells? but not all? – datatoo Oct 12 '10 at 17:58
Mike - I don't have an answer, but I have seen this when taking Excel worksheets from one platform to another and back (Windows/Macintosh). – JDB Oct 12 '10 at 18:26
are you sure the result referenced in the source sheet is not producing the error as well? like a total with errors not allowing a result? – datatoo Oct 12 '10 at 21:13
#Name in some cells but not all is correct - but the row with the #NAME is refering to the same row of data from another book. The source worksheets all show the figures - but I'm wondering if some of those figures might not be in text format without someone realising...I'll need ot haev a look. Thanks for your views. – RocketGoal Oct 21 '10 at 13:58

If you look at the formulae in the destination spreadsheet when you open the source spreadsheet you'll see that they change, and the path part of the filename goes away. This leads me to think that the problem could be to do with the path which was once valid not being valid any more. Has something changed on your network?

share|improve this answer
(late I know) I don't think anything has changed, but in another workook with links I get #Value when I link to an open workbook and then close it. – RocketGoal Jun 22 '11 at 14:16

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .