Skip to main content
skt5435-gmail-co
Nov 6, 2023 11:08 AM UTC
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?

Original commenter did not share additional details

5 replies

GeorgiaC
Nov 6, 2023 12:40 PM UTC

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!

skt5435-gmail-coAuthor
Nov 6, 2023 12:53 PM UTC

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.

emmam6
Nov 6, 2023 1:18 PM UTC

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.
 

skt5435-gmail-coAuthor
Nov 7, 2023 2:59 PM UTC

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
Nov 7, 2023 3:27 PM UTC

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