Updating calculations automatically when i enter in new data
 

Hi,
I use excel to store my data and then i do analysis on the data. New data
comes in frequently, which means i need to make changes to my formulas and my
graphs, which is quite time consuming. So i tried using Define Names to
define a
region, which makes it a bit easier, and then i tried using the OFFSET method
(see http://support.microsoft.com/default...;EN-US;Q183446). But
using that method for big files makes doing calculations slow and excel
recalculates all the time (since OFFSET is a volatile function). Is there
any other method of doing the same method WITHOUT using a volatile function
like indiret( ) or Offset( ).

Have you considered using two spreadsheets? One as a database and one as the
chart? Using Microsoft Query to pull in the new data.

"chica_guapa" wrote:

Hi,
I use excel to store my data and then i do analysis on the data. New data
comes in frequently, which means i need to make changes to my formulas and my
graphs, which is quite time consuming. So i tried using Define Names to
define a
region, which makes it a bit easier, and then i tried using the OFFSET method
(see http://support.microsoft.com/default...;EN-US;Q183446). But
using that method for big files makes doing calculations slow and excel
recalculates all the time (since OFFSET is a volatile function). Is there
any other method of doing the same method WITHOUT using a volatile function
like indiret( ) or Offset( ).