Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a [Excel 2000] spreadsheet that shows a link to another spreadsheet in
Edit/Links. However, I can't find any cell in the spreadsheet that accesses the spreadsheet listed in the link. Also, if I click on the link in Edit/Links, the Update Now is grayed out. How can I delete this link? Whenever I open the spreadsheet, I am asked if I want to update the link, then told Excel can't find it. Thanks, -- Dave |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'd use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm Dave Schreffler wrote: I have a [Excel 2000] spreadsheet that shows a link to another spreadsheet in Edit/Links. However, I can't find any cell in the spreadsheet that accesses the spreadsheet listed in the link. Also, if I click on the link in Edit/Links, the Update Now is grayed out. How can I delete this link? Whenever I open the spreadsheet, I am asked if I want to update the link, then told Excel can't find it. Thanks, -- Dave -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thank you! This found the [lack of] link; then the "list and delete" option
got rid of it (without damage to other, valid links). -- Dave "Dave Peterson" wrote: I'd use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm Dave Schreffler wrote: I have a [Excel 2000] spreadsheet that shows a link to another spreadsheet in Edit/Links. However, I can't find any cell in the spreadsheet that accesses the spreadsheet listed in the link. Also, if I click on the link in Edit/Links, the Update Now is grayed out. How can I delete this link? Whenever I open the spreadsheet, I am asked if I want to update the link, then told Excel can't find it. Thanks, -- Dave -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Could be part of a defined name.
Have a look in InsertNameDefine Gord Dibben MS Excel MVP On Thu, 8 Jan 2009 09:49:04 -0800, Dave Schreffler wrote: I have a [Excel 2000] spreadsheet that shows a link to another spreadsheet in Edit/Links. However, I can't find any cell in the spreadsheet that accesses the spreadsheet listed in the link. Also, if I click on the link in Edit/Links, the Update Now is grayed out. How can I delete this link? Whenever I open the spreadsheet, I am asked if I want to update the link, then told Excel can't find it. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Highlight Expired dates | Excel Discussion (Misc queries) | |||
Gray Out Expired Records | Excel Worksheet Functions | |||
find expired dates =IF((E11-TODAY()<0), "EXPIRED", "OK") | Excel Worksheet Functions | |||
If expired, change color | New Users to Excel | |||
Page expired? | New Users to Excel |