Hey guys,
I seem to be having a problem getting my hyperlinks to stay as I type them. Occasionally (seemingly randomly, I haven't been able to detect a pattern), when I enter a link like so:
=hyperlink("Ficton\Y\Yoked.htm","Yoked")
which seems to work just about every other time, and this is even the filepath given when using the CTRL + K function (which also changes), it changes to:
"file:///C:\Users\Peggy\AppData\Roaming\AppData\Roaming\AppData\Roaming\Microsoft\Excel\Yoked.htm"
and the file won't open. At first I thought the problem might be exacerbated by sorting and filtering, but now I'm not sure. Does anyone have any idea what is causing the filepath to change, or how I can get it to stay?
Thanks!
Bookmarks