| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help: identify where an automatic link to other spreadsheet is?
I have a spreadsheet with links to a couple of other sheets. However, how
can I find out which cells are linking to other sheets if I've forgotten? It is a huge sheet, and when I open it and click "update" it complains about one of the linked sheets being missing - I need to remove the link to that sheet as it's no longer valid, but how on earth do i find out where in my sheet it's looking for this other sheet? surely there must be a simple way to find out? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help: identify where an automatic link to other spreadsheet is?
go to menu Edit Links... and remove the link you do not require. Lee Harris Wrote: I have a spreadsheet with links to a couple of other sheets. However, how can I find out which cells are linking to other sheets if I've forgotten? It is a huge sheet, and when I open it and click "update" it complains about one of the linked sheets being missing - I need to remove the link to that sheet as it's no longer valid, but how on earth do i find out where in my sheet it's looking for this other sheet? surely there must be a simple way to find out? -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=572979 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help: identify where an automatic link to other spreadsheet is?
"starguy" wrote in message ... go to menu Edit Links... and remove the link you do not require. no, that doesn't help - you get that prompt on startup anyway (not to mention the option to break/remove links often crashes excel) I want to know which cells are linking to the external sheets. Lee Harris Wrote: I have a spreadsheet with links to a couple of other sheets. However, how can I find out which cells are linking to other sheets if I've forgotten? It is a huge sheet, and when I open it and click "update" it complains about one of the linked sheets being missing - I need to remove the link to that sheet as it's no longer valid, but how on earth do i find out where in my sheet it's looking for this other sheet? surely there must be a simple way to find out? -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=572979 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help: identify where an automatic link to other spreadsheet is?
Lee
Download and use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP On Fri, 18 Aug 2006 08:28:58 GMT, "Lee Harris" wrote: I have a spreadsheet with links to a couple of other sheets. However, how can I find out which cells are linking to other sheets if I've forgotten? It is a huge sheet, and when I open it and click "update" it complains about one of the linked sheets being missing - I need to remove the link to that sheet as it's no longer valid, but how on earth do i find out where in my sheet it's looking for this other sheet? surely there must be a simple way to find out? Gord Dibben MS Excel MVP |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help: identify where an automatic link to other spreadsheet is?
"Gord Dibben" <gorddibbATshawDOTca wrote in message ... Lee Download and use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP many thanks Gord On Fri, 18 Aug 2006 08:28:58 GMT, "Lee Harris" wrote: I have a spreadsheet with links to a couple of other sheets. However, how can I find out which cells are linking to other sheets if I've forgotten? It is a huge sheet, and when I open it and click "update" it complains about one of the linked sheets being missing - I need to remove the link to that sheet as it's no longer valid, but how on earth do i find out where in my sheet it's looking for this other sheet? surely there must be a simple way to find out? Gord Dibben MS Excel MVP |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Please help: identify where an automatic link to other spreadsheet is?
Thanks Lee
Bill's add-in has saved a lot of work for many over the years. Gord Dibben MS Excel MVP On Fri, 18 Aug 2006 23:32:25 GMT, "Lee Harris" wrote: "Gord Dibben" <gorddibbATshawDOTca wrote in message .. . Lee Download and use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Gord Dibben MS Excel MVP many thanks Gord On Fri, 18 Aug 2006 08:28:58 GMT, "Lee Harris" wrote: I have a spreadsheet with links to a couple of other sheets. However, how can I find out which cells are linking to other sheets if I've forgotten? It is a huge sheet, and when I open it and click "update" it complains about one of the linked sheets being missing - I need to remove the link to that sheet as it's no longer valid, but how on earth do i find out where in my sheet it's looking for this other sheet? surely there must be a simple way to find out? Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| link a entire line in Excel to a spreadsheet I sort? | Excel Discussion (Misc queries) | |||
| Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
| How do i link Excel chart to Outlook automatic emails? | Excel Worksheet Functions | |||
| Automatic update of information in a spreadsheet | Excel Discussion (Misc queries) | |||
| Link Soucre changes when Spreadsheet opened from with within Outlook | Links and Linking in Excel | |||
Hybrid Mode
