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
AS37
Level 3
posted
‎July 29, 2021 02:50 PM
last updated ‎July 29, 2021 11:50 AM

Export to excel error: Excel allows 256 columns in worksheet. This report has 19 columns...

Hello,

I'm trying to export a standard report (19 columns detailed P&L) to excel, but I keep getting the following error

"Excel allows 256 columns in worksheet. This report has 19 columns".  The report doesn't exceed the 256 columns.  

I've just upgraded by office package to E3, so I feel like it's an integration with excel that's not working, but I don't know how to deal with it. 

I'm using remote desktop.

 

Any ideas?

Thanks,

Aksinia

Reply Join the conversation
1 Comment 1
JamesM4
QuickBooks Team
QuickBooks Team
‎July 29, 2021 04:45 PM

Export to excel error: Excel allows 256 columns in worksheet. This report has 19 columns...

Hello Aksinia,

 

It's great to have you reach out to us here. I can see the importance of being able to export your reports and I'll be glad to assist. QuickBooks Desktop is a dynamic program that enables you to complete your work in less time and I'd like to make sure you experience this benefit among many others. 

 

Based on what you've described, there are several causes and solutions to the error you're getting. I encourage you to check out this helpful article here as it shows you how to troubleshoot this issue. It's vital that MS Office is compatible with the version of QuickBooks you're using. The article above explains more about the compatibility requirements. You're more than welcome to reach back to me as you go through the article. 

 

I'll be one message away in case you need anything else. Otherwise, I wish you a great rest of the week. 

Reply Join the conversation
Featured
Update billing, subscription and firm info in QuickBooks Online Accountant
Looking to update billing, subscription, and firm information in QuickBooks...
Read more
New ROE submission process in QuickBooks Payroll
To learn more about the new record of employment submission process in Quic...
Read more
View and print your T4s and RL-1s in QuickBooks Workforce
Learn how you can view and print your own T4s/Relevé1s online or through th...
Read more

Need to get in touch?

Contact us