deleting old links and Update Remote References

[Alec Glaskin]

I use Excel in Office OS X on an iMac G4
I have changed the links in a formula in a worksheet dependent on another
worksheet in the same workbook.
The change works OK but I would like to delete the old links in the
Edit>Links dialog box as I have made several updates to the link and all the
old ones stay visible. I have been unable to do this and cannot find
guidance in Excel Help
Also I cannot change the Automatic Update button in this dialog box to the
Manual Update button. The status of all the Links remain at <A>
I have tried to override this by choosing Preferences>Calculation and
unchecking the <Update Remote Reference>. However, this is command is
checked and greyed, so is unaccessible.
Would appreciate any help

 

[TH]

You probably have not found all the links. They can get there many ways, but
when you find the last one and change that link, then the list of links will
be blank. (You won't even be able to select the menu item).

Try this great add-in. It's probably the most requested help problem and
this thing really works.

Find Link by Bill Manville is at :
Stephen Bullen's web site http://www.BMSLtd.co.uk/mvp

TH