web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Working with Reports s...

Small and medium business | Business Central, N...

Suggested Answer

Working with Reports sent to Excel

(0) Share

Report

Report

Posted on by AccountsPLUS

10

Hi,

when I send a report to Excel and then try to work on the data in excel, I get #value error messages.

This seems to be happening because cells that look blank seem to have something in them.

If I even do "=a1" where a1 looks blank, I get #value.

I have to go to each empty cell and delete that cell to be able to work on the report.

Is there any way around this.

For example the Trial Balance will have blank in at least one of debit or credit.

So working with a trial balance in excel becomes very cumbersome.

Jim

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 102,843 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi, if you choose Excel (data only), you may not have this problem, but then there is only data and no layout.
More details: https://yzhums.com/23873/

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 518 Super User 2026 Season 2

#2

YUN ZHU 362 Super User 2026 Season 2

#3

Grigorios Mavrogeorgis 327 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans