Cannot Auto Update Excel Graphs

[hpang]

I have a very complex spreadsheet and I have created some graphs from it. The data points are formulas that pull data from various sheets on this workbook. These points are also dynamic so when I change a certain value, all the data points may change. When they do change, the graphs do NOT. Even after i recalculate the graphs stay the same.

I have tried these methods and all have failed.
1) Create the graphs on a sheet of their own.
2) Create a new Workbook and link to the datapoints to create the graph. (in this method, the numbers would update just fine, but as soon as I created a graph from the data, the new workbook would not update.)
3) Combinations of both above.

The ONLY way I can get this to work is to save and close the file. Re-open, then caluculate. This for some reason works.

Please help, I have a presentation due today. Thank you all.

 

[rdodge]

I have data in one set of workbooks, graphs in another workbook, and I use a combination of formulae and VBA coding to update the data from the set of individual workbooks to the main summary workbook.

I'm assuming you are currently using Automatic Calculations, of which I do not use Automatic Calculations cause with the formulae that I have put in, each and every time I change something in a workbook, it could take my P3, 800MHz, 384MB SDRAM PC133, 20GB HD (9.34GB Freespace) system anywhere between 2 and 120 seconds to calculate depending on which workbooks I have open within that instnace of Excel. Cause this slows me up and it's not necessary to have calculations done after each and every little change, I have turned off all automatic changes including not calculating before saving. However, I also didn't want to have to manually calculate everything of which at the time when I ran into the situation in January of 1999, I only had Calculate by Sheet available cause pressing the F9 key is not dependable in XL97, and I also found it's not dependable in XL2K or XLXP. However, in XL2K and XLXP, you can press Alt-Ctrl-F9 to force a total recalculation of all open workbooks and worksheets.

In my cause, I decided to use VBA to control when what gets calculated and in what order. I had setup the code to do the calculations by a particular worksheet level, which would be the same as selecting the first worksheet, press Shift-F9, select the next worksheet, press Shift-F9, and so on. I have not had any issues with my graphs updating via this method as I have had with press F9 by itself. I actually pretend as if the ShortCut key of F9 is disabled cause of it's UNRELIABILITINESS of it's function.

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
When the going gets tough, the tough gets going.