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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Export to Excel produc...
Microsoft Dynamics CRM (Archived)

Export to Excel produces blank sheet and ribbon disabled

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

Export to excel (eg from a contacts view) produces an xls with the correct filesize but when it is opened there are no rows and the ribbon is disabled!

This has been working fine up until now. I would be grateful for any ideas...otherwise I suppose I will schedule a server reboot.

Exporting with column headings - to xml - works fine.

Thanks6082.excel.png

*This post is locked for comments

I have the same question (0)
  • JanHoefnagels Profile Picture
    JanHoefnagels 15 on at
    RE: Export to Excel produces blank sheet and ribbon disabled

    Hi, the problem is caused by security settings in Excel.

    Please see http://community.dynamics.com/crm/f/117/t/206155

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Export to Excel produces blank sheet and ribbon disabled

    The reboot solved the Excel problem – but we also updated to CRM rollup 4 (which may may or may not have helped the issue).

    Strangely now the export options are different – the option to export field headers for re-import has disappeared so this must be handled differently now??

  • Community Member Profile Picture
    Community Member on at
    RE: Export to Excel produces blank sheet and ribbon disabled

    Will let you know tomorrow Colin. I don't know exactly when the issue started but we just became aware of it yesterday.

  • forco02 Profile Picture
    forco02 on at
    RE: Export to Excel produces blank sheet and ribbon disabled

    I have the same issue that started today on Dynamics 2015, When I log in to Dynamics from outside the network it also fails in the same way. This is for all users, and was fine yesterday

    I am interested if rebooting the server fixes the problem.

  • Community Member Profile Picture
    Community Member on at
    RE: Export to Excel produces blank sheet and ribbon disabled

    Thanks but it all User acccounts are experiencing it - plus there are no column headers output.

  • CRMYogi Profile Picture
    CRMYogi 505 on at
    RE: Export to Excel produces blank sheet and ribbon disabled

    See if this gets you anywhere

    social.microsoft.com/.../crm-export-to-excel-opens-blank-worksheet

    Regards,

    Yogesh

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
Christoph Pock Profile Picture

Christoph Pock 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans