Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
S
skt5435-gmail-co
November 6, 2023
Question

Reports exported to excel are showing nil values. I see that this problem has been reported in the past but assume that it was never resolved?

  • November 6, 2023
  • 2 replies
  • 4 views
No text available

2 replies

G
GeorgiaC
Level 13
November 6, 2023

Hi skt5435-gmail-co, thanks for joining Community

 

Please select Enable Editing in Excel and the data should then populate. Get back to us below if there are any further issues!

S
skt5435-gmail-coAuthor
November 6, 2023

Hi. I had laready tried that along with some other suggested fixes that appeared in a thread on this topic that appears to have started a few years ago.

E
emmam6
November 6, 2023

Hello Skt5435-gmail-co, Which reports is this happening with? Are you using an Apple device to export (Mac or iOS)? Can we ask you to try to reduce the number of rows by selecting "Show non-zero rows" only - > This reduces the length of the formula and report value is correct' It may be due to an excel limitation. Let us know how you get on.
 

S
skt5435-gmail-coAuthor
November 7, 2023

Hi. This is now resolved as it was the spreadsheet app I was using that caused the problem. Thank you for the suggestions to resolve my query.

Nicole_N
Nicole_NQuickBooks Team
QuickBooks Team
November 7, 2023

You're welcome.

 

We're glad to know that your issue is now resolved. Please don't hesitate to get back to us if you have other QuickBooks concerns. We'd be more than happy to assist. Have a good one!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement