MrExcel Publishing
Your One Stop for Excel Tips & Solutions

deleting web page linked graphic pasted onto sheet


Posted by Dennis Daly on January 22, 2002 3:24 PM

A co-worker was trying to cut and paste data from a web page to a ssheet. The complete page copied and I cannot delete the image. It is an active link, yet I cannot find the cell with active data referencing the image.

I tried cntrl right click to delete or clear contents to no avail.

Any suggestions? I can copy the other data to a new sheet and delete the sheet, but I want to know where the resident image is located.


Posted by Joe Was on January 22, 2002 6:18 PM

Click the image and then right click and "Cut" it, sometimes this will get rid of it?

If this does not work see if a cell has a link to it, by:

Close all workbooks except the one you want to find the links in.
On the Edit menu, click Find.
Click Options.
In the Find what box, enter [.
In the Within box, click Workbook.
In the Look In box, click Formulas.
Click Find All.
In the box at the bottom, look in the Formula column for formulas that contain [.
To select the cell with a link, select the row in the box at the bottom.

If this does not work try:

On the Edit menu, click Go To, and then click Special.
Click Objects, and then click OK.
Press TAB, and then look in the formula bar for a reference to another workbook, such as [Budget.xls]. The name of the object appears in the Name box.
Repeat the previous step until each object is checked.

Or,

Click the text box or chart title you want to check.
In the formula bar , look for a reference to another workbook, such as [Budget.xls].

Or,


On the Insert menu, point to Name, and then click Define.
Select each entry in the Names in workbook list, and look in the Refers to box for links. Links contain a reference to another workbook, such as [Budget.xls].

Microsoft has a utility on the developer site which does all of the above and prints a report about all the inks it finds. The utility takes a long time to run and I do not know the link to it off hand. JSW