I have a summary spreadsheet that has a number of hidden worksheets to summarise. Each hidden worksheet has about 600 cells which each have a simple link to a single cell in another worksheet. e.g.
=...\QESO_MASTER\[VW-P00083_stock.xls]Overview'!A4
Where I am in cell A4 of the hidden worksheet and the link should be just getting the content of cell A4 on the linked worksheet (i.e. VW-P00083_stock.xls).
There are currently about 20 hidden worksheets and 19 iof them are working perfectly.
On the hidden worksheet shown referred to above about 95% of the links work perfectly. The remainder give a "#N/A" error.
I can find no difference on the cells in either the hidden worksheet nor the source worksheet.
HELP!
Microsoft Office