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.

 

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

 

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.

 

Hello Richard,

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

 

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!

 

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.

 

Thanks Thunder

 

Also look at: Edit>Links