Prev: Conditional formatting dates
Next: How do you limit the total allowed for a group of cells?
From: fruitchunk on 4 May 2010 21:44
I have a heavy excel workbook with lots of formulas, every time I did
something it was calculating literally for 20mins, so I changed it to Manual
Calculate. Now lets say I add a column and do calculate now it calculates the
whole sheet/workbook for a very long time. Can I tell it to only calculate
the new cells ? or maybe can I have excel calculate only selected cells?

Thanks
From: Ms-Exl-Learner on 4 May 2010 22:20
Have a look in the below link for more details.

http://www.decisionmodels.com/calcsecretsg.htm

Remember to Click Yes, if this post helps!
------------------------
(Ms-Exl-Learner)
------------------------


"fruitchunk" <fruitchunk(a)discussions.microsoft.com> wrote in message
news:5A7AA521-51D2-4383-BBE0-EA3001CAC71E(a)microsoft.com...
> I have a heavy excel workbook with lots of formulas, every time I did
> something it was calculating literally for 20mins, so I changed it to
> Manual
> Calculate. Now lets say I add a column and do calculate now it calculates
> the
> whole sheet/workbook for a very long time. Can I tell it to only calculate
> the new cells ? or maybe can I have excel calculate only selected cells?
>
> Thanks

From: fruitchunk on 4 May 2010 22:33
I guess I need some kind of VBA code or macro to do Range.Calculate.
Can you help me with that?

"Ms-Exl-Learner" wrote:

> Have a look in the below link for more details.
>
> http://www.decisionmodels.com/calcsecretsg.htm
>
> Remember to Click Yes, if this post helps!
> ------------------------
> (Ms-Exl-Learner)
> ------------------------

From: Ms-Exl-Learner on 4 May 2010 23:12
Go through the below link for VBA code.

http://www.decisionmodels.com/calcsecretsh.htm

Remember to Click Yes, if this post helps!
------------------------
(Ms-Exl-Learner)
------------------------


"fruitchunk" <fruitchunk(a)discussions.microsoft.com> wrote in message
news:458E1588-D7BE-42DE-ABC0-19564E9054B8(a)microsoft.com...
> I guess I need some kind of VBA code or macro to do Range.Calculate.
> Can you help me with that?
>
> "Ms-Exl-Learner" wrote:
>
>> Have a look in the below link for more details.
>>
>> http://www.decisionmodels.com/calcsecretsg.htm
>>
>> Remember to Click Yes, if this post helps!
>> ------------------------
>> (Ms-Exl-Learner)
>> ------------------------
>
 | 
Pages: 1
Prev: Conditional formatting dates
Next: How do you limit the total allowed for a group of cells?