-
Open the problematic Excel file.
-
Copy the value of the unknown function from the original cell to a temporary cell.
-
Copy the unknown function from the log file to the original cell.
-
In Excel 2003, the log files are located in <Smart Instrumentation home folder>\SaveAsExcel\ResultFiles\.
-
In Excel 2007, the log files are located in C:\Documents and Settings\ [user name]\ SPI_SaveAsExcel
-
The file names are created according to the convention LogFileFormXXX_#.txt, where XXX is the form number and # relates to the internal change made to the form.
-
-
In the original cell, modify the exported function to convert it into an Excel function.
-
Move the cursor outside the cell to display the value of the function.
-
Compare the value displayed in the Excel cell with the value in the source specification. If the values are identical, this is an indication (but not a proof) that you have accurately converted the formula.
-
If you succeed in converting the function, delete the contents of the temporary cell.
-
If you re-save the same specification in Excel format, to prevent the software from overwriting your new function, you must rename the corrected Excel file. You can then copy the formula to future Excel versions of this specification.
-
If the converted formula does not work, restore the original cell contents from the temporary cell, and then contact Customer Support.