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 / Customer experience | Sales, Customer Insights,... / Problems opening Dynam...
Customer experience | Sales, Customer Insights,...
Suggested answer

Problems opening Dynamic Worksheet produced from Dynamics 365 Online

(0) ShareShare
ReportReport
Posted on by JonClay

Hi everyone

I've output a Dynamics Worksheet from Dynamics 365 CRM (the data came via a Saved View).

I can open the spreadsheet in Excel for the first time, however when I click Refresh All, all the data disappears and I'm left with a blank Excel spreadsheet.

Does anyone know why this would happen?

Many thanks
Jon

I have the same question (0)
  • Suggested answer
    Tyson Bosse Profile Picture
    Tyson Bosse on at
    RE: Problems opening Dynamic Worksheet produced from Dynamics 365 Online

    My name is Tyson Bosse and I work with our Dynamics 365 Office Integration support team.

     

    This is the article you will need to go through:

     

    Troubleshoot export to Excel - Power Apps | Microsoft Docs

     

    The main issue here will be this url in step 3:

     pastedimage1614985317982v1.png

    We will want it to look like above with the "tweener" information. Sometimes, this will be showing a url for the error message you would get in step 5 below:

     pastedimage1614985350106v2.png

     

    The url gets corrupted if you hit "ok" on this page and then hit "import". The url then is replaced with this error message url instead. There is no way to change or fix this, so you would need to re-export the file to Excel, then when you are prompted for credentials and hit the above error page (this is a good thing). You instead will just close out this error window and then you should be able to refresh the data.

     

    Please run through this to see if it fixes your issue.

    Thanks,

    Tyson

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 109 Super User 2025 Season 2

#2
MVP-Daniyal Khaleel Profile Picture

MVP-Daniyal Khaleel 97

#3
#ManoVerse Profile Picture

#ManoVerse 56

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans