Link error when opening a file

[piannetta]

Hi, I have a spreadsheet that links to several files and every time I open it up, it always throws up an error on one of the linked files saying that it's missing or can't be found. I then go into Edit Link, repoint it to the file location and it works fine after that.

Despite saving it each time, it does the same thing when I reopen it.

The linked file in question has not had a change in name or location, ever. It's stored locally on my computer's HDD so it's not an network drive issue. I just don't know why it keeps "forgetting" where this file is when it doesn't change.

Can anyone help with this please?

Pete