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