Is the workbook a copy of another?
Is one of the tabs either copied from another workbook or moved from another workbook?
Is the workbook “saved As” another file then the links taken out?
All the above I’ve had problems with.
Folks create workbooks then link to sheets they’ve saved locally, when they share them the links busted but either still think the links live or just cant reference the cell location so brings in a blank cell (which then screws up the formula(s))
I don’t know exactly why but some links are ghosted, like they are still there even though you’ve disabled them.
Tried going into settings and opening as a raw file so you just get the results of the formulas or cells without the actual formulas? I have to do this quite often, then I go to the originator of the workbook and wrap the thing around thier head.
Worth a try unless you need the formulas or indeed links.
What version excel? 10??
What I should qualify is T’is, you could save the file as a .CSV then it’ll open as a Raw data file. You can then save that as something else, then open the original workbook and go through to “show formulas” in tools and recreate the formulas in your new file saved.
HTH.
It’s a bit long winded I know, probably a far easier way to sort out your problem but this way I get to understand what the originators workings are like.
