Index-Match Still Displays The Value After The Source Has Already Been Deleted

Hello;

I am working on a worksheet with Index and Match functions. The source of this worksheet is from a different excel file and it is perfectly working fine, until one of my colleagues have done some modifications on the source file. Now I have to create a new source file similar to the corrupted one. Now my problem is, I already deleted the corrupted source file, how come this worksheet with the Index and Match functions is still showing the values from the deleted source file?
Thank you.

Because tables that formulas refer to get 'imported' into the excel file.
This is why file size bloats with more and more formulas.
How this works, and exactly where that data is stored in the file I don't know..

When you open a file with external links, you get the prompt to 'Update Links'
If you select YES, This is when the internal table is updated.
If the source file is gone, and you select yes to up date links you browse to a new file..
If you select NO, then formulas continue to use the table that was previously imported into the file.


At least I believe that's how it works..

Hello XOR LX, the Calculation Mode is always on Automatic... I already did the following:
1. Placed the Calculation Mode to Manual
2. Clicked on the Calculate Now button
3. Clicked on the Calculate Sheet button and
4. Placed the Calculation Mode back to Automatic

Still nothing happens.... It's still getting data/values from the file which I've already deleted.
Where is it getting the data/values from?
Is it like it saved a copy of the source file somewhere else?
I'm really confused and wondering.

001.JPG

Hi Jonmo1;
Yes, everytime I open this file, I always get this "Automatic update links has been disabled" and its got an Option button for me to click on and select Allow or Enable this content... But it's not doing anything... It still gets the data/value from the file I already deleted.

By the way, both files (the CLIENT and the SOURCE) are saved on different folders on a network. I have "FULL" access on both folders. I deleted the SOURCE and the CLIENT is still getting the data/value from I don't know where.

If WorkbookA.xls has links to WorkbookB.xls.
Then the relevant table from WorkbookB.xls is actually imported into WorkbookA.xls.
Where exactly that data is stored in workbookA I don't know, but it's in workbookA.

Formulas actually get their data from the table that was imported into WorkbookA, unless WorkbookB is OPEN.
This is why if WorkbookA is closed, and WorkbookB is open and you make changes to it and save it.
Then open workbookA, and select NO to updatelinks, the old values are still there.

What's even crazier is you can even create a NEW formula that refers to the same table of a deleted book, and it will work.

I went to Edit Links in the Data tab and confirm that the source file is that which I said I have deleted...
and I got this...
002.JPG

and I can't get the deleted file out of the list.

When you edit links, you'll need to choose to Change Source, and browse to a NEW file that contains the data you want your formulas to refer to.

OR,

Copy the formulas, Right Click - Paste Special - Values - OK

"What's even crazier is you can even create a NEW formula that refers to the same table of a deleted book, and it will work."

That is crazy.... BUT IT'S TRUE!