Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
yfegade
Level 3

Quickbooks Report Export to Excel Warning: Excel allows 256 columns in a worksheet

QuickBooks version: QuickBooks Pro Desktop 2021, R8 (Updated on 11/01/2021).

 

When I try to export my Quickbooks report (any report) to Excel, I get following warning:

 

Excel allows 256 columns in a worksheet

This report contains 7 columns (3 row title columns + 4 data columns)

Use "customize" to change the number of columns in this report.

 

Nothing happens when click on "Ok" in that warning dialog. Why would I get that warning when # of columns in my report is less than what Excel will allow? I don't understand how to fix or get rid of this warning.

 

Help, I can't export any of reports to Excel.

Need to get in touch?

Contact us