I have a file that links to about 25 other files. I roll this main file forward each month and when I was on Excel 2007 I was able to be in the main file, go to data>edit links>open source and be be able to open all of the files and then save them into the next month.

Now I am in Excel 2010 and every time I try to open the sources, it says they can't be found and excel has actually dropped part of the path in the file path. Everyone who is still in 2007 can open the source files, but I cannot and it started when I went to Excel 2010.

Does anyone have any suggestions? I'm desperate! What once took 20 minutes now takes almost an hour because I have to manually relink these files every time I need to roll it into the next month.

Also, whenever I open a file that links to supporting files, I have to open each supporting file and each subsequent supporting file in order to update the values in the initial main file. Again, when I was in Excel 2007 I could go data>edit links>update values and everything would update, but when I switched to Excel 2010 it will no longer do this.

Megan