cancel
Showing results for 
Search instead for 
Did you mean: 
Bonner44
Level 1

export to update excel worksheet loses all other worksheets in the workbook

When exporting report to excel to UPDATE and excel worksheet - it updates the worksheet you pick but deletes all other worksheets in that workbook.  How can it Keep the others.

1 Comment 1
Mark_R
QuickBooks Team

export to update excel worksheet loses all other worksheets in the workbook

Hello there, @Bonner44.

 

To update existing worksheet, let's make sure that you select the existing excel file correctly to display all other worksheets. Let me guide you how.

 

  1. Open the appropriate report.
  2. Select Excel on the report.
  3. Choose Update Existing Worksheet.
  4. To select the workbooks, click browse, then choose the existing file.
  5. Select the specific sheet in the file you want to export the report to.
  6. Click Export.

Here's an article you can read for your reference: Export Report from QuickBooks Desktop to Microsoft Excel.

 

If your QB Desktop crashes when exporting a report to excel worksheet, you may check out this article for your future reference: QuickBooks Desktop Crashes When Exporting Report to Excel Worksheet.

 

Fill me in if you have further questions. I'll be around if you need any help.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us