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.