Hello,
I have a class where I generated an excel workbook that has data derived from a datasource. Is it possible to have the excel open by default as a Pivot Table as per the example below instead of the user having to do it manually?
Thank you.
Hi Anthonymgy,
You can filter fields in the open in excel while exporting - But you cannot open excel with pre-defined pivot table.
I cannot confirm that this is not achievable, but it requires more R&D to achieve the same.
Thanks,
Girish S.
Hi Anthonymgy,
Do you mean creating pivot tables through code implementation? I'm afraid not.
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156