Removing a deleted Graph

[Rick Judge]

I am working on a spreadsheet given to me by another person. The person asked me to look at the sheet and fix it so that it no longer promts the user to "update links" when the file is opened. What I have found is that there are several lines in the spreadsheet. These lines are not borders and they are not condensed text boxes. My best guess is that they indicate the location of a graph that existed but the rows surrounding the graph have been deleted and thus all that remains of the graph is this line. I'm also guessing that this graph contains links to another spreadsheet. I can see the spreadsheet name through the edit links function but I cannot find the links to that spreadsheet anywhere in the spreadsheet I am working on. I have literally gone through every cell looking for links to an outside workbook and have found none, therefore the only thing I can think is that links are in these graphs (that are now only represented by a single line) and I have no idea how to get to them or delete them. Can you help me out. Thanks

 

[tusharm]

See if Bill Manville's FindLink add-in helps. It's available from http://www.bmsltd.co.uk/MVP/MVPPage.asp#BillManville

 

[Rick Judge]

That did it. Thank you very much. I downloaded the FileLink.zip file, ran it and the links are gone. I still have the lines from the graphs, but I can live with those. Thanks again.

 

[tusharm]

You are welcome. Glad to be of help. As, I'm sure, is Bill.

That did it. Thank you very much. I downloaded the FileLink.zip file, ran it and the links are gone. I still have the lines from the graphs, but I can live with those. Thanks again.

 

[Jon Peltier]

Rick -

Those lines are in fact charts with zero thickness. Even if you select and delete a range of cells that completely surrounds a chart, the chart remains. Click on the Select Objects button (the cursor arrow on the Drawing toolbar) and select a rectangle around the "lines" you want to delete. Then Delete them.

Or in the Immediate window of the VB Editor, type this line:

ActiveSheet.ChartObjects.Select

Then Shift-Click the charts you want to save, and delete the rest.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______