auto links

dawnfoss · Apr 23rd, 2002, 08:45 AM

I have a spreadsheet that used to be linked to another workbook. I've deleted all links to the other workbook, but cannot seem to get rid of the auto link. Everytime I open up the sheet, it prompts me to find the auto link that does not exist anymore.

Any ideas?

Thanks,
Dawn

Mark W. · Apr 23rd, 2002, 08:49 AM

Did you check for named ranges the reference other workbooks? Try using this...

http://support.microsoft.com/default...;EN-US;q188449

[ This Message was edited by: Mark W. on 2002-04-23 07:51 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 08:45 AM	#1
dawnfoss Board Regular Join Date: Apr 2002 Posts: 91	I have a spreadsheet that used to be linked to another workbook. I've deleted all links to the other workbook, but cannot seem to get rid of the auto link. Everytime I open up the sheet, it prompts me to find the auto link that does not exist anymore. Any ideas? Thanks, Dawn

Apr 23rd, 2002, 08:49 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Did you check for named ranges the reference other workbooks? Try using this... http://support.microsoft.com/default...;EN-US;q188449 [ This Message was edited by: Mark W. on 2002-04-23 07:51 ]