Export for Quickbooks to Excel creates a HUGE file

B

Bill Board

We do a simple export from Quickbooks and there is one page of data but the
file size is 3 MB. if I select just the rows and columns that contain data
and copy them to a new workbook and save it the file size drops to 11K.

I copied the sheet to another workbook and it is the same size.
I saved it in every format I can think of. CSV makes it much smaller, but
lose formatting. Binary makes it smaller, but if I save it back as XLS or
XLSX it is large again.
I've tired clearing all unused cell... which takes too long, but doesn't
work. Same size.

I don't know what it is about this sheet. Any idea??

I have Excel 2007.
 
B

Bill Board

I can do that with the columns ok, but the 65,000 rows takes too long to
select.
 
D

Don Guillett

Use the row numbers section to the left>select the first blank row
number>hold down the shift key>use end +down>delete
 
V

viglen

We do a simple export from Quickbooks and there is one page of data but the
file size is 3 MB. if I select just the rows and columns that contain data
and copy them to a new workbook and save it the file size drops to 11K.

I copied the sheet to another workbook and it is the same size.
I saved it in every format I can think of. CSV makes it much smaller, but
lose formatting. Binary makes it smaller, but if I save it back as XLS or
XLSX it is large again.
I've tired clearing all unused cell... which takes too long, but doesn't
work. Same size.

I don't know what it is about this sheet. Any idea??

I have Excel 2007.

Have you tried to contact the customer support team?
I have used them many times and they are very helpful.
They have different levels of support members to help even the most
complicated questions and problems regarding their POS Software.

1-888-320-7276
QuickBooks: Basic, Pro and Premier and Customer Manager

1-800-348-0254
QuickBooks: Point of Sale

1-866-340-QBES
QuickBooks: Enterprise Solutions

1-800-881-2079
QuickBooks: Simple Start Desktop Edition

Hours of Operation:1
(Pacific time)

Point of Sale:
Mon-Fri 6 A.M. to 8 P.M.
Sat & Sun 7 A.M. to 4 P.M.

All others:
Mon-Fri 6 A.M. to 6 P.M.

Support,
www.AlexandriaComputers.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top