I recently got excel 2007. All my macros and vlook up's do not work in excel
2007. Is there an easy fix to this problem. I have 1000's of files that I use
daily that this effects.
=VLOOKUP($C$1,'\\warren-file\engineering\Starbucks\[Starbucks Shipping
Schedule.xls]SHIPPING'!$D$15:$Y$600,2,0)

This is one of my vlookup that work in excel 2003 but not in excel 2007.
How do I make this work?
Thanks