dsmith

No its not one about Puff's courier company.....

The wife (an accountant - zzzzzzz) has a spreadsheet which claims to have links to other spreadsheets. The pther sheets havbe long since disappeared and she wants to clean the links out....

But she cant find them. Even if she turns formulas on and searches for the sheet names they're not there, yet the links box still shows then and it still complains about them when you open the main sheet.

Anyone got a util or macro to list the links in an Excel spreadsheet and more importantly the Cells which reference those links - or even just delete phantom links ??

Ta

Deano

Puff The Magic Wagon!

iTrader: (2)

Thanks for the plug

Is it in hidden cells/rows?

I quite often wack a formula in & then hide it for the sake of tidyness & for the reason I don't know better

Sheepsplitter

From the EDIT menu you will have a LINKS menu.
On that you can change the links.
As far as I know there is no way of deleting them from this menu, but at least you can find them all and manually delete them.
Alternatively you could change them all to a file you know exists, either way it should address your problem.

dsmith

Unfortunately the Links dialog doesn't show where the links are used. We know they're therebut cant find the little blighters.

Martingb

Depending on the size of the spreadsheet, copy all the sheets to a new workbook. This then "loses" the non-existant links.

Martin.