MrExcel Publishing
Your One Stop for Excel Tips & Solutions

update links

Posted by Andrew Miller on February 12, 2002 11:33 AM

I have a workbook that, every time I open it, excel asks if I would like to update links. As far as I know it shouldn't be referencing any other workbooks and therefore shouldn't have any links. I have searched all formulas for "[" (brackets) which is what surrounds the name of the referenced workbooks in a formula and I don't find any. Anybody have any ideas?

Posted by Chris D on February 12, 2002 2:18 PM

this is a pain

there's probably a better way, or a more efficient addin, but I create a blank worksheet and save it on my desktop as links.xls

then in you rproblem file, goto : edit, links and change the scource of any dubious ones to read cell A1 in your blank links.xls desktop file

then go to the desktop file and move the first sheet with A1 in it *to* your dubious file, thus pointing the link back to the same file and save.

it shouldn't ask for a link next time you open it as it resides within the same worksheet.

pretty pathetic, eh ?!