referencing another file

[srmorgan]

I have a worksheet that, when it loads, asks me if I want to update the data from another file.
For the life of me, I can't figure out which cells in this spreadsheet are pulling values from this other spreadsheet.
Is there a way to find out which cells are referencing the other sheet. This is a big file, 28 columns, 14,000 lines.

Thanks to all

Steve

 

[Mudface]

Try a search on the site for delete or remove links, there's been many questions on this previously, probably because it's such a pain in the bum . Microsoft also do an Add-In called DelLinks (I think) which you should be able to download from MS support.