MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Linking dates in excel workbook


Posted by Susan on August 25, 2001 7:28 AM

I am linking 2 workbooks. When I enter info into book 1 it should automatically update book 2. In book 1 a cell is blank until I put in a date, in book 2 it shows up as 1/00/00, or 01/01/1900 when it should be blank. What am I doing wrong? I have tried everything and read just about everything I can find with no results. Help!!!


Posted by Aladin Akyurek on August 25, 2001 7:45 AM

I reckon you have a formula in workbook 2 that reads a relevant cell from workbook 1. And the cell of this formula is date formatted. If so, change that to

=IF([MyBook.xls]Sheet1!A1,[MyBook.xls]Sheet1!A1,"")

Aladin