View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HBj[_2_] HBj[_2_] is offline
external usenet poster
 
Posts: 9
Default Non-actual external links remain

Hello,

I have a lot of Excel workbooks (2000/2003 and 2007). In some of them I
have used external links in worksheet cells - like VLOOKUP etc. I have
however removed those formulas, but nevertheless, when I open such a
workbook, Excel wants still refresh the links. I have searched in
worksheets, macros and Add-Ins for scraps of those links, but never found
any. Today I created a new workbook, copied from an old workbook only one -
more or less empty - sheet. I immediately saved the new book and reopened.
All those old annoying links were copied to the new book!!! Where are they
hidden? Is there any other solution than creating the workbook from scratch?
I know, I can ignore to update the links, but still it is annoying.

--
Håkan