Unlinking an excel spreadsheet?

Office 2000 running on Win XP. I have some Excel spreadsheets that I originally linked to other spreadsheets when I created them. I have done some work on the new ones but would like to unlink them. Every time I open the new spreadsheets I get the pop-up that asks about automatically updating the linked information, and I click "No "

Is there any way to see which cells are linked? I can use the links menu item from the tool-bar but this just shows the spreadsheet that I am linked to and doesn't appear to offer any way to unkink.

How do you unlink the cells. I presume that I could copy and paste values for all the cells but then I would lose any formulas.

Thanks,
Rob

 

Open the sheet that contains the links.

Go to Tools> Options > View TAB

Under window options put a check by Formulas and say OK.

This will show you all the formulas in the whole spreadsheet, and then you can go through and delete those links you no longer want.

(remove the check when finished)

 

Thank you - I had not figured out how to show the formulas and by following your suggestion I found one cell that somehow was linked externally to a temp file!

Many thanks Ana, and to everyone else who helped,

Rob