Hi all,
I have a spreadsheet that retrieves about 150 totals from about 50 different spreadsheets. The original workbook works fine when it's open and I can edit it, and the linked workbooks work fine when they're open as well.
But the moment I open the main workbook AND open any linked workbook right after it, the linked cells go from:
'FilePath\[Filename]Worksheetname'!$E$23
to:
'[Filename]#REF'!$E$23
which breaks all the links to the opened sheet. I don't lose all 150 links, just the ones that linked to the opened workbook.
Closing the linked workbook doesn't help, the File Path returns but links stay broken because the Worksheetname remains as #REF.
Does someone understand what's going on here? Why would it change the name of the worksheet inside the cell to #REF?
I should mentioned that I moved all the files to a shared drive before this happened. I used a macro to replace all the links with the correct links. I know the links are correct after I use the macro because I can change any of the linked workbooks and it will update in the main workbook. But the moment I open the main workbook and any linked workbook together, I lose that set of links.
Anyone seen this before? I appreciate any help or direction.
Bookmarks