Q
Question
We have encountered an apparent bug in Excel 2007: it appears that any cells
using formulas from the Analysis Toolpak add-in (analysis32.xll) from older
versions of Excel are eventually corrupted when opening the file in Excel
2007. The functions from this add-in (such as eomonth) are now inherent in
Excel 2007, but the formulas when created in a previous version with the
toolpak get corrupted in Excel-07, and #N/A is placed in the cell.
using formulas from the Analysis Toolpak add-in (analysis32.xll) from older
versions of Excel are eventually corrupted when opening the file in Excel
2007. The functions from this add-in (such as eomonth) are now inherent in
Excel 2007, but the formulas when created in a previous version with the
toolpak get corrupted in Excel-07, and #N/A is placed in the cell.