Prev: Counting Days
Next: counting identical items in a column and returning the occurre
From: vijay on 26 Mar 2010 22:23
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?
From: Don Guillett on 27 Mar 2010 08:28
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
dguillett(a)gmail.com
"vijay" <pv.cn1.gj(a)gmail.com> wrote in message
news:622ee0ae-1d6f-48f4-86f6-58e0392ac64e(a)x23g2000prd.googlegroups.com...
>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?

 | 
Pages: 1
Prev: Counting Days
Next: counting identical items in a column and returning the occurre