vlookup errors out when i change the data in the source file

Hi guys!

Something weird is happening...I have a file called "Style Master" that I use as a source file for multiple VLOOKUPS in several other files. I've never had a problem with it until I was upgraded from Excel 2007 to Excel 2010 last week.

Now, with no rhyme or reason, all of the external links to that file randomly error out, and I need to repoint the formulas to the table array. I don't delete any rows or columns; I just add new data, so I don't know why the references would become #REF. It happens whether or not the source file is open.

This is what it looks like:

BEFORE: VLOOKUP($A7,'[Style Master.xlsx]style master - current'!$A:$X,12,FALSE
AFTER: VLOOKUP($A7,'S:\Allocation\Tools\[Style Master.xlsx]#REF'!$A:$X,12,FALSE (source file was open here - I had just added new info)

I would really appreciate any help, as I use the Style Master in multiple files every day and it's annoying to have to constantly redo my formulas.

Thank you!
Cicely

no, nothing in the file changed aside from the addition of data to the table.

Is anyone else experiencing this? It keeps happening, regardless of which source file I use. I use a lot of templates, and each time I make a change within any of my source files (not renaming files or sheets), I get reference errors.

Ok I finally figured it out....all my files were created in Excel 2007, and when opened in Excel 2010, the external links to the source file wouldn't hold for some reason. I needed to resave the source files (and the source files only) in Excel 2010, and all my formulas worked fine - even if I didn't resave any of the other files that were pulling from them (though I think I'm just going to resave everything in 2010 just in case).

Weird, I thought there were only compatibility issues between 2003 and 2007+, but I guess there are some between 2007 and 2010 as well.