Quickbooks Export to specific Excel worksheet

How do I export a Quickbooks file to a specific Excel worksheet?

I am using Quickbooks Pro 2007 on a single-user desktop. I have had success exporting a file into Excel if I let it create a new worksheet. However, if I specify a worksheet, it gives me a "Server busy" error with "switch to" and "retry" options.

Amanda replies:

I’m not sure why it will not allow you to specify a file. Select ‘export’ then choose ‘existing excel workbook’. Browse to your excel file and press ‘open’. Then select an existing sheet or new sheet in the workbook. You may want to also click on the bottom choice that explains worksheet linking-it may help. This should work very easily. If it’s not working, the only thing I can suggest is to create a new excel workbook and copy the worksheet over into your existing excel file. It may be a compatibility issue…..which is not my expertise.

Amanda at univamgroup@yahoo.com

Easy & Inexpensive
QuickBooks Help:

image of 27 QB mistakes ebook cover

"Conquer 27 Frustrating Mistakes that Steal Your Time, Sanity & Money!"

QB Mistakes are
Costly & Unnecessary

27 QB mistakes & their solutions, demonstrated in detail.

Two FREE Bonuses Included! Only $9.97.
Instant Download.

Learn More Here


Add to Cart

image of COGS ebook cover

"Crack the COGS Code"

Too Little COGS?
Too Much Taxes!

QB does NOT use the traditional COGS formula to compute your COGS!

Only $9.97. Ebook.
Instant Download.

Learn More Here


Add to Cart

Click here to post comments

Return to QuickBooks Q&A.