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!