I recently did some end-of-the-year organizing of my computer files. In the process I moved some Excel files that were linked to a completely separate “totals” worksheet. Now every time I open my “totals” worksheet, a box pops up that says the computer cannot find the files and I have to go through and show it where each of the five or six files is now. I thought that if I saved the “totals” file before closing it would remember where the moved files are, but, alas, I’ve had to re-show it where they are every time. Does anyone know what I have to do to make it remember? Any help is much appreciated! Thank you!
Amy
