web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... D365 FO Excel Open as ...

Finance | Project Operations, Human Resources, ...

Answered

D365 FO Excel Open as Pivot Table by default

(0) Share

Report

Report

Posted on by Anthony90288

87

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 Img

All responses (2)

Answers Img

Answers (2)

Verified answer

huijij 19,811 on at

Like (1)

Report
Copy link

Link copied!

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,833 Moderator on at

Like (1)

Report
Copy link

Link copied!

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

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 545 Super User 2026 Season 1

#2

Giorgio Bonacorsi 408

#3

Adis 267 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans