Hi everyone,
After writing an appended collection to master excel file, when I refresh the file using MS Excel VBO with action 'RefreshPivotTable' I am getting an error : “The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field.”
Before this page executes I am able to manually refresh the excel file, but When I try to manually refresh after it failed I get the same error as mentioned above. This was working fine earlier for a long time. There was no changes made to write collection action, so I am not sure why it is failing.
Please suggest what maybe going wrong. Thank you.
After writing an appended collection to master excel file, when I refresh the file using MS Excel VBO with action 'RefreshPivotTable' I am getting an error : “The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field.”
Before this page executes I am able to manually refresh the excel file, but When I try to manually refresh after it failed I get the same error as mentioned above. This was working fine earlier for a long time. There was no changes made to write collection action, so I am not sure why it is failing.
Please suggest what maybe going wrong. Thank you.