Prev: Range Vlookup
Next: Help, help! desparate for formula help!!
From: Subodh on 25 Apr 2010 23:54
I have some data that are calculated once in an array.
Now, as the calculations are very time consuming, so i won't like to
perform the calculations again.
So, for the first time the workbook is opened, it should do the
calculations and then proceed with other
operations in the code that uses the numbers inserted in the array.
And, for the next time onwards, it should not do the calculations (as
i want to have the numbers already in an array), it should only do the
operations after the calculations.
This saves time significantly as the time consuming calculations are
not performed each time.
But, as i distribute the workbook to many users on different
computers, it should first check the computer if the values are there
in registry
and if not it should do the calculation else retrive data from the
registry.
T0 large numbers of data, lets say 10000 into registry is also a
problem, i felt
Further, I wonder if there is any alternative way to solve the
problem.
Any tips in this regard will be appreciated.
From: Tim Williams on 26 Apr 2010 00:11
Save the numbers on a hidden worksheet.

Tim

"Subodh" <getsubodh(a)gmail.com> wrote in message
news:d8d95b01-15d7-4b95-8086-909526d110e4(a)m24g2000prc.googlegroups.com...
>I have some data that are calculated once in an array.
> Now, as the calculations are very time consuming, so i won't like to
> perform the calculations again.
> So, for the first time the workbook is opened, it should do the
> calculations and then proceed with other
> operations in the code that uses the numbers inserted in the array.
> And, for the next time onwards, it should not do the calculations (as
> i want to have the numbers already in an array), it should only do the
> operations after the calculations.
> This saves time significantly as the time consuming calculations are
> not performed each time.
> But, as i distribute the workbook to many users on different
> computers, it should first check the computer if the values are there
> in registry
> and if not it should do the calculation else retrive data from the
> registry.
> T0 large numbers of data, lets say 10000 into registry is also a
> problem, i felt
> Further, I wonder if there is any alternative way to solve the
> problem.
> Any tips in this regard will be appreciated.


 | 
Pages: 1
Prev: Range Vlookup
Next: Help, help! desparate for formula help!!