I have a user that created an excel model and linked the cells to multiple workbooks in the network drive. When he save the files and open it next time. the source location of the model has changed to "C:\Users\user profile\AppData\Roaming\Microsoft\Excel\".
I can edit the links to correct the issue but have multple files like this. I want to understand why this happen and prevent it from happening again.
Any feed is greatly apprecitated.