Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlinks fail after saving
hyperlink in excel fails after saving... \\server\folder\subfolder\file.xls
tunrs to //server/folder/subfolder/file.xls after saving. thus, i get error message " the address for this site is not valid. Check the address and try again" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlinks fail after saving
Not sure how you're creating the hyperlink, but one like that should look like
file:///\\server\folder\subfolder\file.xls to work properly. To check, I just set one up on my system here, using insert hyperlink and closed the workbook, and when I opened it back up, it was formatted properly. "Eric Lee" wrote: hyperlink in excel fails after saving... \\server\folder\subfolder\file.xls tunrs to //server/folder/subfolder/file.xls after saving. thus, i get error message " the address for this site is not valid. Check the address and try again" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlinks fail after saving
l use the Insert - Hyperlink as well.
the address to which i am linking is on our shared server thus the address would be \\server\folder\subfolder\file.xls when i create this hyperlink, it works okay as long as i dont save it. however, when i save the file and re-open it, the links dont work any more. although, they hyperlinks to the websites within my company still works. the links to the shared server does not work as it changes to ".../folder/subfolder/file.xls " as seen on the address box when you view the hyperlink property. dont know why \ changes to / after saving. "JLatham" wrote: Not sure how you're creating the hyperlink, but one like that should look like file:///\\server\folder\subfolder\file.xls to work properly. To check, I just set one up on my system here, using insert hyperlink and closed the workbook, and when I opened it back up, it was formatted properly. "Eric Lee" wrote: hyperlink in excel fails after saving... \\server\folder\subfolder\file.xls tunrs to //server/folder/subfolder/file.xls after saving. thus, i get error message " the address for this site is not valid. Check the address and try again" |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
hyperlinks fail after saving
The only thing I can think of would be a setting in AutoCorrect that is
changing it? Might look in Tools | Options | [Spelling] tab, [Auto Correct Options..] button. Check the list to be auto corrected and see if somehow a setting of from \ to / got put in there? If that's not it, I'm afraid a wiser head than me is going to have to jump in and help. I just seem to be missing something here. At a different machine now and I went thru these steps in a new workbook: typed in some text in a cell, chose that cell and used Insert | Hyperlink in 'Link to' I made sure [Existing File or Web Page] was chosen along with "Look in" of [Current Folder] then I used the pull down and selected My Network Places and browsed to a drive on another system and chose a file there. The text immediately changed to hyperlink format (blue underlined text) and hovering over it showed the hyperlink to be: File:///\\Antec\Documents\Somefile.xls closed and re-opened the workbook and it was still that way, as it should have been. "Eric Lee" wrote: l use the Insert - Hyperlink as well. the address to which i am linking is on our shared server thus the address would be \\server\folder\subfolder\file.xls when i create this hyperlink, it works okay as long as i dont save it. however, when i save the file and re-open it, the links dont work any more. although, they hyperlinks to the websites within my company still works. the links to the shared server does not work as it changes to ".../folder/subfolder/file.xls " as seen on the address box when you view the hyperlink property. dont know why \ changes to / after saving. "JLatham" wrote: Not sure how you're creating the hyperlink, but one like that should look like file:///\\server\folder\subfolder\file.xls to work properly. To check, I just set one up on my system here, using insert hyperlink and closed the workbook, and when I opened it back up, it was formatted properly. "Eric Lee" wrote: hyperlink in excel fails after saving... \\server\folder\subfolder\file.xls tunrs to //server/folder/subfolder/file.xls after saving. thus, i get error message " the address for this site is not valid. Check the address and try again" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlinks fail after saving | Excel Discussion (Misc queries) | |||
Help with hyperlinks in pulldown list. Anyone know how? | Excel Discussion (Misc queries) | |||
Help with hyperlinks in pulldown list. Anyone know how? | Excel Worksheet Functions | |||
Still need help with hyperlinks in pulldown list. Anyone know how | Excel Discussion (Misc queries) | |||
Saving Hyperlinks | Excel Discussion (Misc queries) |