I have a reporting package that gets created every month that is linked to multiple files to pick up the current month and YTD data. I am however, having a problem with several links reverting back to the previous month's data even after updating the links and saving the file. Here are the steps I take:
1. Copy November file into a December folder and rename to December
2. Open new December file
3. Go to linked cell and double click to update links to the file I am getting data from
4. Verify data is pulled in correctly and save
5. Close file and reopen to check that everything is updated

Everything always looks fine initially, but at any point in the future I may open my monthly file and it will revert back to the data that was in the file from November. The source file is the same for the entire year (no monthly copies). I am linked to a YTD number that stays in the same cell, but changes value monthly as more data is added.

Has anybody had this same experience? If my explanation needs further clarity, please let me know and I'll post additional info.

I am on Excel 2000