Cyberdude
01-28-2010, 08:49 PM
About 10 years ago I created a set of about 50 formulas each having its own defined name in about 30 Excel 2003 workbooks. The formula for a typical one of these defined names looks like the following:
Defined Name = CurrCellD2P3]
Refers To:
Offset(Indirect(Address(Row(),Column()), 3, 2)
When I started opening my workbooks created with Excel 2003 and containing a set of these formulas with defined names, at some point Excel 2007 removed EVERY occurrence (including the name definitions) from the workbooks. I got no error message anywhere that suggested that Excel 2007 was making this change to my workbooks.
My question is what rule have I violated that caused Excel 2007 to make these disasterous changes??
Sid
Defined Name = CurrCellD2P3]
Refers To:
Offset(Indirect(Address(Row(),Column()), 3, 2)
When I started opening my workbooks created with Excel 2003 and containing a set of these formulas with defined names, at some point Excel 2007 removed EVERY occurrence (including the name definitions) from the workbooks. I got no error message anywhere that suggested that Excel 2007 was making this change to my workbooks.
My question is what rule have I violated that caused Excel 2007 to make these disasterous changes??
Sid