Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i locate the cell linking to another spreadsheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i locate the cell linking to another spreadsheet
When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm jolson wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i locate the cell linking to another spreadsheet
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]? "jolson" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A cell in an excel spreadsheet that does not print but shows in pr | Excel Discussion (Misc queries) | |||
One spreadsheet cell won't print but shows up in print preview? | Excel Discussion (Misc queries) | |||
how do I reference a spreadsheet in a cell | Excel Worksheet Functions | |||
Format spreadsheet so no input allowed if certain cell is =<0 | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |