Error message. Outputting an Excel doc to PDF.

Error Message

Excel to PDF - Different Values

Cause

Outputting an Excel doc 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.

&==SUM(Z15*P49)-P49