I use an Excel spreadsheet that is updated daily. It links to a separate workbook that also gets daily updates. Recently, I moved both files to Dropbox, and then a few days later moved them back to my local drive. On the second move, Excel lost track of the path to the linked file. I have tried updating the location using the pop-up window that appears when the files are first loaded; I have also tried editing the formulas that include the links. Nothing seems to stick. An additional concern is that rows for prior days show the "Dropbox" path, which is no longer valid.

Any help will be much appreciated.

Allan