Excel - linked Spreadsheets

Hello Wendy

Thank you for your question.

If you choose not to update initially (so you can first check which cells would update), then you might be able to use the Find feature to identify cells with links, as long as you know what the name of the file is that the links are to.

You can find out the name/s of files that are linked to a spreadsheet by going to Edit - Links. The name/s of the file/s are shown in the Source column.

Once you know the name of the file/s that your spreadsheet is linked to, then go to Edit - Find (or Ctrl + F) then under Find what enter the filename of the linked spreadsheet.

Check next to Linked in that Formulas is selected, then click Find All. A list of the cells that are linked to the file should display in a box at the bottom of the screen. If you click on one of the cells listed, that cell will be selected for you automatically in the spreadsheet.

I hope this helps.
Amanda