how do i locate the cell linking to another spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

on opening spreadsheet a, i am always asked if i would like to update links.
one link reference is to spreadsheet c, which i open and update regularly.
the other is to spreadsheet b, which i haven't used in over a year. is there
an easy way to locate the cell(s) on the tab(s) in spreadsheet a which
contains the link(s)?

it is likely that the update-requesting link to spreadsheet b is no longer
needed, and that i could simplify my process be deleting the cell(s) and
tab(s).

thanks, Jack
 
Maybe you could try Edit-Find and put the symbol [ in the box (or xls ) to
find all square brackets or xls - the links have to refer to another
spreadsheet by [otherspreadsheetname.xls]?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Significant DELAY to open spreadsheets containing regular links? 6
Unlink cells- how? 0
Changing linked worksheet and range of cells 7
linking excel spreadsheet from network 3
no cells, grey screen, all tabs greyed out 2
Linked Spreadsheets in Excel 2003 3
can a linked spreadsheets sort automatically when data is added 2
How do I find cells with linked content 5

Back
Top