Exactly what did you do when you "updated" for 2006? HTH Otto
"hdmas" wrote in
message ...

I have an excel worksheet with 9 worksheets on it. It is a daily
summary sheet for all the days in a fiscal year. I have vlookups
running to make calculations over fiscal weeks and months. This
spreadsheet worked fine for all of 2005. I updated the spreadsheet for
2006 and now it only works for the first fiscal week. Anyone know what
could be causing this error?


--
hdmas
------------------------------------------------------------------------
hdmas's Profile:
http://www.excelforum.com/member.php...o&userid=31284
View this thread: http://www.excelforum.com/showthread...hreadid=509523