Thread: View links to other worksheets

Hi everyone.

I have just completed a massive reorganisation of my accounting spreadsheets and have ended up with some dozen or so worksheets in one workbook with multiple cross linking within the book. That is fine and works well, BUT in order to set up the new system I have copied pages from the old system and in the process somewhere there is still a link to the old workbook.
Does anyone know how I can find that link without having to examine each and every cell of the new workbook?
Because I have moved the old workbook into an archive directory, when I open the new book I get the option to enable links but of course when I try to update the links it cannot find the old data and produces an error condition. - most annoying and I would like to get rid of it so if anyone can tell me how to find the link I would be most grateful

Thanks,
David

Edit > Links > Break Links.


This will convert the cell with the link into a flat value, so at least the link will be gone.

Hi David and welcome to the board,

Any links to other workbooks should have brackets [] around it, so maybe the find feature.

http://www.ehow.com/how_7270297_link...readsheet.html