referencing another file

srmorgan · May 7th, 2002, 01:42 PM

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 · May 7th, 2002, 02:02 PM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 01:42 PM	#1
srmorgan Board Regular Join Date: Apr 2002 Location: Wilmington North Carolina USA Posts: 61	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

May 7th, 2002, 02:02 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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.