Posted by Philip Pallette on January 30, 2002 6:41 AM
A workbook arrived at our firm this morning that the user opened up in Excel 2000 and got a ?NAME error throughout several cells.
The cells contained the formula HPVAL(,,,,,,). I believe this function has something to do with hyperextension.
I suggested the user open the spreadsheet in Excel 97. He did and it worked.
How do I get this file to work in Excel 2000? Will saving it in Excel 2000 as an Excel 2000 workbook convert the function?