Limited time only. 90% off QuickBooks for 6 months.
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
ErinChambers
Level 1

creating new worksheet from report - error

I'm trying to create a New Worksheet from a report.  I've done this thousands of times.  Today, it is giving me a Warning, saying "Excel allows 256 columns in a worksheet.  This report has 61 columns (4 row title columns + 57 data columns.  Use "customize" to change the number of columns in this report).   

 

A couple of issues here:

- why did this just start happening?

- if excel allows 256 columns, why am I getting a warning when my report has only 61 columns?

- I can't find anywere in Customize to adjust the number of columns in the report.

- if it's a "warning", why can't I continue?  

Solved
Best answer November 28, 2025

Best Answers
JoesemM
Moderator

creating new worksheet from report - error

Welcome to the Community forum, Erin, Let's address the error message you're encountering while attempting to create a new worksheet from your report.

 

It's likely that your report did not exceed  the column limit, but the warning may have been triggered due to an open QuickBooks dialog box interfering with its internal export process. To resolve this issue, make sure all dialog boxes are fully closed to allow QuickBooks to complete the export efficiently.


To close those open dialog boxes:

 

  1. Press Alt+ Tab in windows.
  2. Cycle through open windows to check for any QuickBooks dialog boxes (warning messages, confirmation, or background windows).
  3. Close any open dialog boxes you find.

 

Once done, export the report again. Then, ensure that any minimized or hidden dialog boxes related to QuickBooks are completely closed before proceeding with the export.

 

Should you have any other QuickBooks concerns in the future, don't hesitate to post again. We're here to help.

View solution in original post

2 Comments 2
JoesemM
Moderator

creating new worksheet from report - error

Welcome to the Community forum, Erin, Let's address the error message you're encountering while attempting to create a new worksheet from your report.

 

It's likely that your report did not exceed  the column limit, but the warning may have been triggered due to an open QuickBooks dialog box interfering with its internal export process. To resolve this issue, make sure all dialog boxes are fully closed to allow QuickBooks to complete the export efficiently.


To close those open dialog boxes:

 

  1. Press Alt+ Tab in windows.
  2. Cycle through open windows to check for any QuickBooks dialog boxes (warning messages, confirmation, or background windows).
  3. Close any open dialog boxes you find.

 

Once done, export the report again. Then, ensure that any minimized or hidden dialog boxes related to QuickBooks are completely closed before proceeding with the export.

 

Should you have any other QuickBooks concerns in the future, don't hesitate to post again. We're here to help.

ErinChambers
Level 1

creating new worksheet from report - error

I couldn't find any tabs open, so completely shut down and restarted... there must have been something hiding, as it's working perfectly now.  Thank you for your quick response.

Need to get in touch?

Contact us