| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
File Size
I have an excel file which contains 150 columns by 1000 rows. Each of the
cell has a value. Then there are 4 other sheets with similar number of rows and columns and contains formulas linked to other sheets. The file size has become a humungous 20 MB!! Not only this file but any other excel file operates very slowly (macros run very slow). is there a way to reduce the file size? |
|
#2
|
|||
|
|||
|
Hi
Have a look he http://www.contextures.com/xlfaqApp.html#Unused It might help. -- Andy. "Pradip Jain" wrote in message ... I have an excel file which contains 150 columns by 1000 rows. Each of the cell has a value. Then there are 4 other sheets with similar number of rows and columns and contains formulas linked to other sheets. The file size has become a humungous 20 MB!! Not only this file but any other excel file operates very slowly (macros run very slow). is there a way to reduce the file size? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
| excel file size bloat | Excel Discussion (Misc queries) | |||
| Deleted all images but file size still too big!! | Excel Discussion (Misc queries) | |||
| Excel file size increased | Excel Discussion (Misc queries) | |||
| Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) | |||
Linear Mode
