Get 50% OFF QuickBooks for 3 months*

Buy now
United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
yfegade
Level 3
posted
‎November 03, 2021 08:45 PM
last updated ‎November 03, 2021 8:45 PM

QuickBooks report: Export to Excel warning: Excel allows 256 columns in a worksheet

QuickBooks Pro Desktop 2021, R8

 

Whenever I try export my reports in Excel, I get following warning:

 

Excel allows 256 columns in a worksheet

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

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

 

Why would my report fail to export Excel when # of columns are less than what Excel allows? How to fix this warning?

 

I can't export any of my reports to Excel since I applied R8 on 11/01/2021.

Reply Join the conversation
3 Comments 3
DebSheenD
QuickBooks Team
QuickBooks Team
‎November 03, 2021 10:57 PM

QuickBooks report: Export to Excel warning: Excel allows 256 columns in a worksheet

Hello, yfegade.

 

I've already answered a similar question you've posted. You can view her answer through this link: https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/re-quickbooks-report-export...

 

In addition, I've included this article that'll help you fix issues when exporting reports: QuickBooks Desktop crashes when exporting reports to Excel worksheet.


I'll be glad to help you again if you have more questions about exporting reports. Just add the details in the comment section.

Reply Join the conversation
yfegade
Level 3
‎November 04, 2021 07:37 AM

QuickBooks report: Export to Excel warning: Excel allows 256 columns in a worksheet

Sorry, I did not mean to post it twice

Reply Join the conversation
MonicaM3
Moderator
Moderator
‎November 04, 2021 07:59 AM

QuickBooks report: Export to Excel warning: Excel allows 256 columns in a worksheet

No problem @yfegade.

 

Let us know how it goes, and feel free to circle back with any additional questions. We're a quick reply away!

Reply Join the conversation
Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Featured
When are taxes due? 2026 Critical Tax Deadlines
 (view in My Videos)
Read more
Quick Answers: A Mini Guide to W-2s
  Hello QuickBooks users, and thanks for joining us. We want to ensure you ...
Read more
Understanding Common Payroll Deductions
 (view in My Videos)NOTE: For more information on deductions, check out our...
Read more

Need to get in touch?

Contact us