tFileExcelWorkBookSave not updating Pivot table

[dorel14]

Hello I have a job with TFileExcelWorkBookOpen that open a template workbook

In the workbook 2 sheets

• 1 with a table
• 1 with a pivot table made with data from table on first sheet

• tFileExcelSheetOutput => to update data in table => This works perfect

TFileExcelWorkBookSave => this save the workbook but pivot table is not refreshed

My talend version is 7.3.1 tFileExcel version 12.5

[jlolling]

Could you please post here a screenshot from your job design? Please take care you trigger the tFileExcelWorkBookSave with an OnSubjobOk because otherwise it is possible the actual post processing of the component tFileExcelSheetOutput is not done. I had mad such mistake and it took many hours for me until I realised the problem.

[dorel14]

Here it is

[dorel14]

hello some news ??

[jlolling]

The formula evaluation is not the function which refreshs the pivot table. Please take care the pivot-table is configured as "update when document is opened".

[jlolling]

In my tests it works this way. Did you see the updated table in the data sheet?

[jlolling]

Does my explanation solved your issue? If not we can have a zoom session to figure out what went wrong. Please contact me directly jan.lolling@gmail.com