Excel2007 Replace formulas with {=#Value!} when saving file

  • Thread starter Thread starter Arthur
  • Start date Start date
A

Arthur

The file is in Excel 2003 (created in Excell 2003) format. "FileName
[Compatibility Mode] ..." displayed on title bar when loaded in Excell 2007.

There are several worksheets in the workbook with array formulas referring
to other worksheet. When saving the file a message pops up saying "saving
this file in 2003 format will lose information, formulas will be converted
to {=#Value!} as the 2003 format cannot handle the quatity of formulas in
this workbook". If you select "Continue" that is exactly what happens: poof,
most of your array formulas are replaced.

Well Excel 2003 handles them perfectly. It is Excel 2007 in Compatibility
Mode that cannot.

Bottom line: if you have Excel 2003 files with a lot of array formula, you
cannot use Excel 2007 and hope to keep these files working (for your
coworkers who still use a pre-Excel 2007 version of Excel !!!
 
Arthur said:
The file is in Excel 2003 (created in Excell 2003) format.
"FileName [Compatibility Mode] ..." displayed on title bar when
loaded in Excell 2007. ....
. . . When saving the file a message pops up saying "saving
this file in 2003 format will lose information, formulas will be
converted to {=#Value!} as the 2003 format cannot handle the
quatity of formulas in this workbook". . . .
Click to expand...
....

Care to show us a few examples of what these formulas should look
like? And how many formulas are there?
 
There are literally thousands of array formulas in this workbook. Excel 2007
[compatibility mode] keeps a few thousands formulas to what there should be
then convert the rest of them to {=#Value!}.

Excel 2003 had no problem with this workbook.

Excel 2007 handles it properly after converting the workbook to the new 2007
format.

Harlan Grove said:
Arthur said:
The file is in Excel 2003 (created in Excell 2003) format.
"FileName [Compatibility Mode] ..." displayed on title bar when
loaded in Excell 2007. ...
. . . When saving the file a message pops up saying "saving
this file in 2003 format will lose information, formulas will be
converted to {=#Value!} as the 2003 format cannot handle the
quatity of formulas in this workbook". . . .
Click to expand...
...

Care to show us a few examples of what these formulas should look
like? And how many formulas are there?
Click to expand...
 
Back
Top