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 Names to define a
region, which makes it a bit easier, and then i tried using the offest 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( ).