Hello,
In the attached project, there is an excel document (Source.xlsx), which has two sheets.The first sheet (Report) is the report we wish to save to PDF.The second sheet (DataTable) is the table of data used for the source of the report (in the final template, this sheet would be hidden)Data is added to the DataTable sheet, and the report is saved as a PDF document (Report.pdf) and a copy of the changed spreadsheet is saved (Report.xlsx).
When first loaded, the report (this is a test case, so it’s just three cells with formulas) will show the data as calculated from the template data source (OLD1, OLD2 and OLD3).The test case overwrites the data with three new entries (New1, New2 and New3).However, when the formulas are re-calculated, instead of showing New1, New2 and New3 as expected – and as how excel would calculate then – the report will show Column1, Column2 and Column3 (the headers).But, if you open the saved copy of the changed spreadsheet, excel will auto refresh the formulas and show the correct data (New1, New2 and New3).