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

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Edit In Excel shows no...
Business Central forum

Edit In Excel shows no data

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

When I look at the General Ledger Entries table or the VAT Entries Table and click on Edit In Excel, I do not see any data in the Excel workbook - I see the column headings but no data in the rows below. There is data in the table when I view it in Business Central.

Any ideas why this would be?

I have installed the Microsoft Dynamics Excel Add-in and I'm signed into Microsoft Dynamics.

I'm in the UK and using Chrome. I 'm using Excel 365.

Thanks,

Steve.

Categories:
Other
I have the same question (0)
  • Suggested answer
    Mustufa Shehreyar Profile Picture
    Mustufa Shehreyar 1,070 on at

    @Steve: Please check if a company is selected under the settings icon.

    If a company is not selected the table would always retrieve (null) blank values.

  • Suggested answer
    Julien PKF Cooper Parry Profile Picture
    Julien PKF Cooper P... on at

    Hello,

    I find that sometimes you need to update the server URL with that of your tenant URL, under the setting icon (the cog in the add-in window).

    Then clicking OK refreshes the data.

    Thanks,

    Julien

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

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

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