Hyperlink Changes

[high.storm]

Opened a spreadsheet (Excel 2003) I use frequently with numerous hyperlinks in it - almost all pointing to files elsewhere on my C: drive - to find that every hyperlink has been "readdressed" (with the correct filename) to the Excel folder buried in Documents and Settings/Username/Application Data/Microsoft/. Of course, none of the files that the hyperlinks point to reside there! So, two questions please. 1. Is there any way to get all the hyperlinks pointing back to the correct (and, incidently) default file location (at specified under Tools/Options) without doing each one individually?, and 2. what could have caused this to happen in the 1st place - would love to dodge this bit of merriment in the future! Many thanks to any and all.....Dan

 

[the_bogan]

With regards to why did it change, I find that happens when I've been moving a file around, or logging in under a different account. (I'm also on a shared network, if that makes a difference)

 

[RoryA]

Do you have a hyperlink base set in the document properties? (File-Properties)