Skip to main content
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
  • 0 views
Original commenter did not share additional details

2 replies

G
GeorgiaC
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_N
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!

Terms & ConditionsAccessibility statement