|
|
||||||
|
#1
06-22-07, 12:29 AM
|
|
|
|
|
Email hyperlinks pop up as I try to access each cell. I've tried turning
off hyperlinks (TOOLS: AUTOCORRECT: AUTOFORMAT AS YOU TYPE. Under REPLACE AS YOU TYPE, I have selected "CLEAR INTERNET AND NETWORK PATHS.... AND CHECKED THE APPROPRIATE BOX.) but that doesn't do it. I have tried doing it to the entire docdument, to individual rows, columns and cells but it dosen't help. I sent a spread sheet to someone who could not use it due to all the hyperlinks opening. She copied the info to a word file, then transferred the data from there to a new excel file and it worked perfectly. She sent it back to me...... and when I tried to use it...... THe hyperlinks popped up again. HELP! |
|
|
|
#2
06-22-07, 12:57 AM
|
|
|
|
|
That Autocorrect setting will stop new hyperlinks from appearing. It won't
remove the existing hyperlinks. If you want to remove the hyperlinks: Select the range to fix (all the cells???) hit alt-f11 (to get to the VBE--where macros live) hit ctrl-g (to see the immediate window) type this and hit enter: selection.hyperlinks.delete Then alt-f11 to get back to excel and test out your changes. jacob735 wrote: [..] |
|
|
| Similar Threads | |
| Is there a way to permanently turn off hyperlinks in Excel 2002 In Excel 2002: When summing a column of numbers, the total becomes a hyperlink. It is possible to remove the hyperlink (or several hyperlinks) after the fact but I want to... |
|
| Update 2000 Excel hyperlinks to 2003 hyperlinks I have a spreadsheet with 20,000 hyperlinks to music files. I formed them with 2000 Office, but have now upgraded to 2003 Office and find the old hyperlinks do not work. I... |
|
| Hyperlinks and Email Addresses in Excel Why is the formatting of email addresses in Excel so problematic? When I enter an email address into a cell it automatically creates a hyperlink. I don't want it to do... |
|
| Excel Hyperlinks- cell content v. hyperlinks I have a column containing company names. Each company name has the hyperlink address to the company website. This is shown in the ScreenTip when the mouse is hovered over... |
|
| Turn on Hyperlinks in Email? HELP! I used to get an option that allows me to turn on my hyperlinks or download pictures in emails I get. Now I don't get that option. When I click on a hyperlink, I get the... |
|
|
All times are GMT. The time now is 01:15 AM. | Privacy Policy
|
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up !