web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Dynamic Pivot Table Issue - No Data

(0) ShareShare
ReportReport
Posted on by 575

From the advanced find I am exporting to excel.  If I choose Static worksheet with records from this page - there are no issues.  If I choose Dynamic Pivot Table or Dynamic worksheet - no data shows up in excel.  I get the error "This field has no items".

I have done the following to try and solve this issue, but none have worked. 

1. I have enabled macros in excel (it prompts every time, anyway to get this setting to stick?)

2. I have created an ODBC connection to the database.

Any help would be great!

 

 

*This post is locked for comments

I have the same question (0)
  • Leon Tribe Profile Picture
    7,034 on at

    I have never seen that error but you can make the settings stick by adjusting your Excel security to allow macros. Obviously this increases security risk.

    Leon Tribe

    Want to hear me talk about all things CRM? Check out my blog

    http://leontribe.blogspot.com/ 
    or hear me tweet @leontribe

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans