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?

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!

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.

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.
 

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.

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!