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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Business Central forum

Edit in Excel

(0) ShareShare
ReportReport
Posted on by 449

Hi everyone,

When i click on "Edit in Excel" from Customer List page in D365BC, exported excel sheet only contains header/Captions and no data of customers.

Please suggest.

Thanks in Advance.

Categories:
I have the same question (0)
  • Suggested answer
    AJAnsari Profile Picture
    5,754 on at

    Hi Manish,

    What version of Excel are you using? If I recall correctly, the Microsoft Dynamics add-in works with Excel 2016 and Excel on the Web (with Office 365 business editions).

    When you open your exported file, look at the pane on the right side of your Excel spreadsheet, and you will see the plugin. If you're not already signed in, you will need to sign in with your Business Central login and password. If you are not an Office 365 user, this will not work for you. (Also, if you have an Office 365 user login, but your admin has not assigned a license that contains access to Office apps like Excel, this will not work for you.)

    Then, you will need to click on Refresh in the same Microsoft Dynamics pane on the right side in Excel, and this will fill your Excel spreadsheet with your Customers list.

    I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"

  • Manish Ratan Profile Picture
    449 on at

    Thanks AJ for reply. Will do the needful and update on this.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans