Scotsman

iTrader: (3)

I'm running Excel 2007 and have a large spreadsheet that has some cells that are linked to another external spreadsheet (message when saving). However, I can't find where they are.

Does anyone know how to find cells in excel that reference a different external spreadsheet? (rather than me checking every single cell).

Cheers
Richard.

DJ Dunk

iTrader: (5)

Make sure all other spreadsheets are closed and do a find for the string [*] (or just a square bracket) within formulas.

Scotsman

iTrader: (3)

Thanks DJ

The error is

"Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the 255-character limit cannot be returned."

Unfortunately I don't know what the string is - just that it's an external link. Any ideas on what I could search on?

Many thanks
Richard.

DJ Dunk

iTrader: (5)

Hello Richard,

I search for just for [ within formulas should show all cells with an external link in them?

Scotsman

iTrader: (3)

You're spot on (did a test) - but it's not finding anything. Weird - must be a problem somewhere else on the sheet and excel is giving a false message.

At least there's no external links though.

Thanks for the help!

Thunder77

If its not too big you can also press CTRL + ` which will switch to view formula mode. You could then quickly scan the workbook. Press same to go back to normal mode.

Scotsman

iTrader: (3)

Thanks Thunder

Dracoro

Also look at: Edit>Links