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.

DELETE rows and columns, not clear, SAVE workbook

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bill Board" wrote in message
...
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.

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

"Don Guillett" wrote in message
...
DELETE rows and columns, not clear, SAVE workbook

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bill Board" wrote in message
...
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.

Use the row numbers section to the leftselect the first blank row
numberhold down the shift keyuse end +downdelete

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bill Board" wrote in message
...
I can do that with the columns ok, but the 65,000 rows takes too long to
select.

"Don Guillett" wrote in message
...
DELETE rows and columns, not clear, SAVE workbook

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bill Board" wrote in message
...
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.

On Feb 2, 8:48*am, "Bill Board" wrote:
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