Different values appear in PDF from Excel file ouput.
Outputting an Excel document to PDF and the Excel document provides the correct values, but the PDF version (using FP0 parameter) shows different values in some of the cells.
If you open the Excel document and do not click the Enable Editing, the values will match up between the PDF and Excel output. It's only when you select Enable Editing that Excel runs the calculations and updates.
WHAT TO DO
To have the formulas calculated when outputting into PDF, they will all need to have the prefix of &= if the formula only shows once or &=& if the formula repeats down the rows.