Home » Forums » Open Source Learning Center » Question and Answer

Edit links

Submitted by sukanyap on 27 January, 2013 - 17:27

When I open an excel sheet it says that the sheet has cells with external links. When I click on the Edit links in the data tab, it shows the excel sheets to which my sheet is linked to but I want to find out the cell within my sheet that refers to those external sheets. Please help.

‹ VBA - Compare Table Header with Merge Rows Modify Recorded Macro to Insert Rows in any Area ›
»
Nick's picture

look for "xls" and that will

Submitted by Nick on 27 January, 2013 - 19:48.

look for "xls" and that will find the cells .. most often it's in charts, so look at the source data for the charts

more here:

86. Excel Tips - Find Broken Links

 

»