|
Export for Quickbooks to Excel creates a HUGE file
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. |
Export for Quickbooks to Excel creates a HUGE file
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. |
Export for Quickbooks to Excel creates a HUGE file
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. |
Export for Quickbooks to Excel creates a HUGE file
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 |
| All times are GMT +1. The time now is 03:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com