I have a workbook with 2 worksheets, the first one contains data which is then summarised in the second worksheet in the form of 2 graphs and 1 table. I'm having a problem with the table not displaying correctly when converting to PDF, all the values in the table are 0 when in the Data worksheet there are values for each of the cells.
This works fine when creating the workbook in Excel format, so i'm wondering whether it has something to do with the cells not being updated as they are referencing cells in another Worksheet. In Excel I think it recalculates the values on opening the file, but when converting it to PDF it doesn't have a chance to do this which could be why this is happening.
If you have any suggestions please could you let me know?
Thanks