Someone help!
I have a huge workbook that has about 20 external links, but there's one file in particular that causes a #NAME? error when it's open at the same time.
Details:
1. I open the workbook, have tried to open it, both with updating links and by continuing without updates.
2. I open the external workbook, and everything connected to it errors out.
3. If I close that external workbook, the errors remain, but will go away if I enter the cell and calculate (F2 then enter) or if I go in "Edit Links" and "Update Values" for that file.
What is happening?
Bookmarks