| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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! |
|
#5
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleted all images but file size still too big!! | Excel Discussion (Misc queries) | |||
| Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) | |||
| File size increase | Excel Discussion (Misc queries) | |||
| WHY IS MY FILE SO BIG? How can I reduce the size of a file? I h. | Excel Discussion (Misc queries) | |||
| I need to download an exel spreadsheet file. (file extension :xls) | Excel Discussion (Misc queries) | |||
Hybrid Mode
