Replies (7)
Please login or register to join the discussion.
Have you tried ...
Clicking on a cell to see where it is getting the information, and then checking the source?
The problem will be on another worksheet somewhere. Have you deleted a worksheet or overwritten the data?
An @NAME? error is an error in a formula. It's either missing or corrupt. If an icon appears when you click on a cell with the error you can then click Trace Error and Excel should find it.
Hi, I have this problem sometimes. Usually if I've opened the accounts workbook by going through "libraries - documents - etc" the figures on the net profit line show this error. I have found though if you open Excel first and then open the document this way you don't get the error..........Hope this helps. :)