I'm having a very strange thing happen:
I have a workbook which is used to invoice an agency and it is used every month based on data in the different sheets, one for each month.
so i have a sheet for each month, named september05, october05, november05, december05, etc.
These sheets are identical - i use the same one every month, just change the names.
in these worksheets, i have a named range named "FirstDayOfMonth". this is a date.
i have another workbook named invoice. this workbook has a cell (c3) which looks at the "FirstDayOfMonth" from the sheet that it is linked to. so if it's linked to september05.xls, c3 should say "September 2005" based on the date 9/1/2005 which is the value of FirstDayOfMonth in that sheet. in the invoice workbook, i have a button which the user clicks so that they can change the linked workbook to a different month. they find the correct book, say October, and c3 changes to October 2005.
the problem:
through October, it all works fine. when i try linking to november or later, c3 in invoice comes up as January 1900.
Does anyone have any idea why this is happening? when i link to one sheet it's recognizing the name, when i link to another, it no longer recognizes it???
thanks in advance
tkaplan