Calculations

[Steve]

HI, I have a spreadsheet that is updated daily with new data.

When the data is added I need to calculate it but it takes forever
even though I have filtererd the data to show that days data only.

Does anyone know if the calculation is being carried out across all of
the data evfen though I have filtered by todays date or, if there is a
a quciker way to run the calculations across the cells that have
formulas for that day only.

Thanks in advance


Steve

 

[Claus Busch]

Hi Steve,

Am Mon, 28 Oct 2013 16:09:32 +0000 schrieb Steve:

When the data is added I need to calculate it but it takes forever
even though I have filtererd the data to show that days data only.

have a look:
http://msdn.microsoft.com/en-us/library/aa730921.aspx


Regards
Claus B.

 

[Steve]

Hi Claus, I hope you are well.

Thanks for the link I will have a read

Regards


steve

 

[Claus Busch]

Hi Steve,

Am Mon, 28 Oct 2013 16:32:04 +0000 schrieb Steve:

Thanks for the link I will have a read

I am fine, thank you.

If you have much array formulas your calculation will take a long time.
In this case you should decide to use helper columns that you can use
normal formulas or do the calculation with VBA.


Regards
Claus B.