MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Removing automatic links

Posted by Barry Ward on August 22, 2001 5:34 AM

I have a number of spreadsheets which I don't want linked. Can I remove the links to prevent them from updating?

Posted by Loren on August 22, 2001 12:12 PM

find the formulas and point them to the open file or
change to hard numbers. Use Edit Links to find the formulas.