HELP PLEASE on Auto-Adjusting Reference

Hello everyone!


I have this problem with this specific file I have. Everything else is good and working except this one. I have 17 different files which are somewhat linked all together using their references respectively. Except this one file.

Case:

These set of files are to be used by multiple computers. All sheets are working properly except that there's this workbook I have that prompts me every time I transfer the folder which contains all these files in a different computer. The prompt asks me to EDIT LINKS which means it does not recognize the link/reference the cells it should address to.

pic1.jpg

Issue:

The issue is subjective to this file only. All other files are auto adjusting by itself when I transfer to other computers. The references of these files are under the condition that the folder must be transferred to the desktop of the computer of which it should be given to.

The references where it says (as an example):

Please Login or Register  to view this content.

where the PRINCIPAL'S OFFICE is the name of the user of the computer. If I use my computer at home, it automatically changes to WEDZMER.

Please Login or Register  to view this content.

However, in one file, it doesn't do that.

Problem:

What should I do in order for this file to STOP PROMPTING ME TO EDIT LINKS and automatically generate to the USERNAME of that computer it would be open to?

In simple press Alt+E+K and click Change Source and locate the file and give Ok...

What happens if you open the source file and see whether the links are getting changed automatically?

My first (and probably only suggestion): Do the files have to be stored on "user's" desktop? As you note, each user's desktop has a unique path. I would suggest storing the source files in one of the public folders, which should have the same path for all users.

I do not know when MS introduced it, but I think it was about Windows XP where MS created a "public documents" folder. In Windows 7, which I currently use, if I navigate to the documents folder, there are two choices -- my documents and public documents. I believe that MS created this public documents folder for this sort of thing -- a folder to store files that all users of the computer can use.

I can see the difference, but I don't really understand it. I expect it is some minor detail that is overlooked at the time the spreadsheets are created or the links are created. A difference in the where the files are saved at the point of creation, or something like that that causes Excel to store the path to each link differently.

Same suggestion -- make sure these "shared" files are stored in some kind of public or shared directory where the path to it will always be the same. That way, as files are updated and created, they will eventually all end up pointing to the same location for the source files, and you will get fewer files with this kind of error.

Instead of storing the file in 'C:\Users\Wedzmer\Desktop\ try storing the file in C:\Users\Public\Public Desktop\ or C:\Users\Public\Public Documents\