How do I reduce the size of an exel file?
 

I am currently up to 80mb and am using Excel 2002. The file has multiple
users with pivot tables. It would be a huge endeavor to reset all the pivot
tables. Is there any other trick that will help reduce the size of the file?

eselgar wrote:
I am currently up to 80mb and am using Excel 2002. The file has multiple
users with pivot tables. It would be a huge endeavor to reset all the pivot
tables. Is there any other trick that will help reduce the size of the file?
What does the file contain and what do you mean by "multiple users with
pivot tables"?

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

Eselgar,

This site gives a few solutions:

http://www.ozgrid.com/Excel/ExcelProblems.htm

Also search the internet for "reduce excel file size" or "excel file size
bloat".

----
Regards,
John Mansfield
http://www.pdbook.com

"eselgar" wrote:

I am currently up to 80mb and am using Excel 2002. The file has multiple
users with pivot tables. It would be a huge endeavor to reset all the pivot
tables. Is there any other trick that will help reduce the size of the file?

Historical sales data. There are several users of this file in the
organization, each creating several pivot tables. We have went through and
deleted some of these and archived the old data and were able to reduce the
size about 50%

"Gordon" wrote:

eselgar wrote:
I am currently up to 80mb and am using Excel 2002. The file has multiple
users with pivot tables. It would be a huge endeavor to reset all the pivot
tables. Is there any other trick that will help reduce the size of the file?
What does the file contain and what do you mean by "multiple users with
pivot tables"?

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk

eselgar wrote:
Historical sales data. There are several users of this file in the
organization, each creating several pivot tables. We have went through and
deleted some of these and archived the old data and were able to reduce the
size about 50%


Can the users not create a pivot table in a new sheet and then move the
sheet to a new workbook?


--
Registered Linux User no 240308
Just waiting for Broadband to complete the conversion!(3 weeks and
counting!)
gordonATgbpcomputingDOTcoDOTuk
to email me remove the obvious!