Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

open in Excel option not showing data

(1) ShareShare
ReportReport
Posted on by 534
Hello Experts,
 
one of my user is facing an issue that when he opens the data according to the given picture, the excel file is showing no data even data is there.
 
[Obsolete] sales order header and lines... i know its obsolete but a few days before he is using this, and data was showing when he uses this option. 
 
pls see the pic to know more detail about this and advise me how to resolve it.
 
////
 
 
 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,162 Super User 2025 Season 1 on at
    open in Excel option not showing data
    Hi Yasir,

    Thanks for your reply and confirmation your issue is solved. Would you mind marking the reply with the correct answer to set the status of this question to Answered?
  • YasirShahzad Profile Picture
    YasirShahzad 534 on at
    open in Excel option not showing data
    Hello Andre,
     
    I have this version.. 10.0.39.. but excellent and always helpful your suggestions resolve the issue... filter were apply, i just removed and its working fine now..
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,162 Super User 2025 Season 1 on at
    open in Excel option not showing data
    Hi Yasir,
     
    I tried this same entity and is working for me in a 10.0.38 environment. When the Excel workbook is opened, can you check the filters in the Dynamics connector? Maybe it is having a wrong order reference?
  • YasirShahzad Profile Picture
    YasirShahzad 534 on at
    open in Excel option not showing data
     
     
    Hello Andre,
     
    there is no change in security permissions, other options are working fine, but only highlighted entity showing no data during extraction.
     
     
     
    Regards
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 292,162 Super User 2025 Season 1 on at
    open in Excel option not showing data
    Hi Yasir,
     
    Do you mean to say the same data entity gave data a few days back and now not anymore? Have you checked if there is a change applied to the security permissions?
  • YasirShahzad Profile Picture
    YasirShahzad 534 on at
    open in Excel option not showing data
     
    can you pls share the process of cache removing in D365
     
    thanks in advance
  • YasirShahzad Profile Picture
    YasirShahzad 534 on at
    open in Excel option not showing data
     
    thanks for your response, actually user uploading data on regular basis through this, i know data can be obtain from data entities but here scenario is different, user uploading bulk data through this functionality and its not working now.
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    open in Excel option not showing data
    Hi,
    You can try another way to export the data. If users are unable to access the data through the open in Excel option, you can try other export options such as using data entities or reports to export the data and see if you can successfully obtain the data. Or you can also try restarting the server. This problem may be caused by the server's cache.
    Best regards,
    Kevin
  • Suggested answer
    BillurSamdancioglu Profile Picture
    BillurSamdancioglu 16,620 Most Valuable Professional on at
    open in Excel option not showing data
    Can you please try to delete the cache?
  • YasirShahzad Profile Picture
    YasirShahzad 534 on at
    open in Excel option not showing data
    Dear Waed,
     
    thanks for your response, i have tried other options and its working fine..

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans