Free Support Forum - aspose.com

How to force a pivot table to recalculate/refresh in code?

Hi ,

We are using .NET cells, and we have ta scenario where a workbook has a data area, and a pivot table that sits on top of thi data area. We are writing code that will change this data area, and we would like to trigger the refresh of the pivot at this point in time ( as opposed to refreshing it when the user opens the workbook ). How do we do this?

The reason for wanting to refresh the pivot table is that we want to extract a value from this table ( in code ) for use in code elsewhere.

Thanks,

James

Hi James,

Thank you for considering Aspose.

Well, I am afraid; your requested feature is not support yet. We have registered your request in our issue tracking system with issue id CELLSNET-11812. We will look into it and see if we can support it in the near future.

Thank You & Best Regards,