Updating calculations + graph when i enter in new data WITHOUT OFF
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( ). |
All times are GMT +1. The time now is 05:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com