This project has moved and is read-only. For the latest updates, please go here.

Refresh Pivot Tables using EPPlus

Jan 6, 2015 at 1:11 PM

I have a multiple pivot tables per worksheet (multiple worksheets) in one excel file. The sources of the pivot tables are hidden worksheets. Is there any way to refresh all pivot tables using EPPlus?
Actually I need to refresh pivot tables and delete hidden worksheets inside the excel file situated on my server(where I don't want excel to be installed). Deletion of the worksheets is trivial but couldn't find anywhere if it's possible to refresh pivot tables and how.