Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete several hyperlinks in an Excel spreadsheet?
Some of my technicians have hyperlinks embedded in their excel spreadsheets
that they can't see. We know they are there when they pass the mouse over the cell it gives them a "hand" with the name of the link. This is causing the file size to be very large. How do we remove the invisible hyperlinks and stop them from happening in the future |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete several hyperlinks in an Excel spreadsheet?
Used to drive me nuts too. I found this in the Excel help files:
1. Type the number 1 in a blank cell, and right-click the cell. 2. Click Copy on the shortcut menu. 3. While pressing CTRL, select each hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) you want to deactivate. 4. Click Paste Special on the Edit menu. 5. Under Operation, click Multiply and then click OK. "trainer07" wrote: Some of my technicians have hyperlinks embedded in their excel spreadsheets that they can't see. We know they are there when they pass the mouse over the cell it gives them a "hand" with the name of the link. This is causing the file size to be very large. How do we remove the invisible hyperlinks and stop them from happening in the future |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete several hyperlinks in an Excel spreadsheet?
a faster option
in vba "activesheet.hyperlinks.delete" -- --- zz [MX] cuasi-musico,semi-poeta y loco "s31064" wrote in message ... Used to drive me nuts too. I found this in the Excel help files: 1. Type the number 1 in a blank cell, and right-click the cell. 2. Click Copy on the shortcut menu. 3. While pressing CTRL, select each hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) you want to deactivate. 4. Click Paste Special on the Edit menu. 5. Under Operation, click Multiply and then click OK. "trainer07" wrote: Some of my technicians have hyperlinks embedded in their excel spreadsheets that they can't see. We know they are there when they pass the mouse over the cell it gives them a "hand" with the name of the link. This is causing the file size to be very large. How do we remove the invisible hyperlinks and stop them from happening in the future |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete several hyperlinks in an Excel spreadsheet?
I know this may seem silly, but where/how do I paste this statement into
Visual Basic? Do I replace "activesheet" with the name of the worksheet that has the hyperlinks? Thanks! "zz" wrote: a faster option in vba "activesheet.hyperlinks.delete" -- --- zz [MX] cuasi-musico,semi-poeta y loco "s31064" wrote in message ... Used to drive me nuts too. I found this in the Excel help files: 1. Type the number 1 in a blank cell, and right-click the cell. 2. Click Copy on the shortcut menu. 3. While pressing CTRL, select each hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) you want to deactivate. 4. Click Paste Special on the Edit menu. 5. Under Operation, click Multiply and then click OK. "trainer07" wrote: Some of my technicians have hyperlinks embedded in their excel spreadsheets that they can't see. We know they are there when they pass the mouse over the cell it gives them a "hand" with the name of the link. This is causing the file size to be very large. How do we remove the invisible hyperlinks and stop them from happening in the future |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete several hyperlinks in an Excel spreadsheet?
select the range with the links (the whole worksheet??)
hit alt-f11 to get to the VBE hit ctrl-g to see the immediate window type this and hit enter: selection.hyperlinks.delete trainer07 wrote: I know this may seem silly, but where/how do I paste this statement into Visual Basic? Do I replace "activesheet" with the name of the worksheet that has the hyperlinks? Thanks! "zz" wrote: a faster option in vba "activesheet.hyperlinks.delete" -- --- zz [MX] cuasi-musico,semi-poeta y loco "s31064" wrote in message ... Used to drive me nuts too. I found this in the Excel help files: 1. Type the number 1 in a blank cell, and right-click the cell. 2. Click Copy on the shortcut menu. 3. While pressing CTRL, select each hyperlink (hyperlink: Colored and underlined text or a graphic that you click to go to a file, a location in a file, a Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP sites.) you want to deactivate. 4. Click Paste Special on the Edit menu. 5. Under Operation, click Multiply and then click OK. "trainer07" wrote: Some of my technicians have hyperlinks embedded in their excel spreadsheets that they can't see. We know they are there when they pass the mouse over the cell it gives them a "hand" with the name of the link. This is causing the file size to be very large. How do we remove the invisible hyperlinks and stop them from happening in the future -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh an excel spreadsheet on a scheduled basis | Excel Discussion (Misc queries) | |||
Excel 2000: How do I delete the hyperlinks in Browsed Pages | Excel Discussion (Misc queries) | |||
Converter from MS Works 4.5 spreadsheet to MS Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2K3: Opening a spreadsheet, also opens book1.xls? | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |