The issue is, I have a data sheet and a pivot sheet together in a workbook.
Pivot sheet is based on the data sheet. I give the necessary pivot configuration settings while preparing the workbook.
When I finally open the excel, the pivot is displaying data only when the data sheet is also available.
When the data sheet is hidden using setVisible to false, the pivot is not fetching any data and showing blank.
This is an urgent requirement and can you please provide a quick resolution to this!
Thanks in advance