Z
zimster165
I have received an excel spreadsheet that has an unusual function i
several of the cells. An example follows:
Cell C17 reads: =add_months(C16,6,"NO_CHANGE","NYC")
When viewing this spreadsheet on an Excel 97 SR2 w/ Windows 95, th
result equals cell C16 (a date field) + 6 months (it seems to behave a
the author intended). When trying to view the same document on Exce
2K, XP, or 2003 running WinXP, the result is #NAME, and the error i
that it does not recognize the add_months function.
The Excel 97 machine does not have any user-defined functions fo
add_month, nor does it exist as a regular or add-in function. Ther
are no macros on the machine or on the document. Adding subsequen
cells at the end of the column using the same syntax on the Excel 9
machine also results in the #NAME error. I can find no special codin
for the individual cells that would allow for this function. Ca
anyone tell me how I can get the spreadsheet to behave properly on
machine with Excel 2k, XP, or 2003? Thanks
several of the cells. An example follows:
Cell C17 reads: =add_months(C16,6,"NO_CHANGE","NYC")
When viewing this spreadsheet on an Excel 97 SR2 w/ Windows 95, th
result equals cell C16 (a date field) + 6 months (it seems to behave a
the author intended). When trying to view the same document on Exce
2K, XP, or 2003 running WinXP, the result is #NAME, and the error i
that it does not recognize the add_months function.
The Excel 97 machine does not have any user-defined functions fo
add_month, nor does it exist as a regular or add-in function. Ther
are no macros on the machine or on the document. Adding subsequen
cells at the end of the column using the same syntax on the Excel 9
machine also results in the #NAME error. I can find no special codin
for the individual cells that would allow for this function. Ca
anyone tell me how I can get the spreadsheet to behave properly on
machine with Excel 2k, XP, or 2003? Thanks