ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to reduce size of ms excel file-2003 (https://www.excelbanter.com/excel-discussion-misc-queries/260046-how-reduce-size-ms-excel-file-2003-a.html)

vijay[_4_]

How to reduce size of ms excel file-2003
 
I am usung excel 2003. A file containing 6000 records and 85 columns
and used formula in each cell becomes a larger size and dificult in
saivng. It takes more time. some time error occures "memory not
enough". Is there any solution in excel 2003?

Don Guillett[_2_]

How to reduce size of ms excel file-2003
 
If your formulas refer to more rows/columns than necessary, change it.
If data no longer needs to be dynamic, Change formulas to values

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"vijay" wrote in message
...
I am usung excel 2003. A file containing 6000 records and 85 columns
and used formula in each cell becomes a larger size and dificult in
saivng. It takes more time. some time error occures "memory not
enough". Is there any solution in excel 2003?




All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com