D365 FO Excel Open as Pivot Table by default

(0) Share

Report

Posted on by Anthony90288

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.

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

huijij 19,811 on at

Like (1)

Report

Hi Anthonymgy,

Do you mean creating pivot tables through code implementation? I'm afraid not.

Was this reply helpful? Yes No
Verified answer

GirishS 27,827 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No