Excel Chart Problems

J

Jason Whitman

We have an excel sheet that is quite complex. We have a chart that is linked
to several cell containing results of a bunch of calculations. When we
chnage parameters in those series the calculations are updated but the chart
will not contain the changed data until we shut down the sheet and reopen
it. We would like it to update in real time. Any ideas?

Jason
 
C

Carey Frisch [MVP]

Please visit the experts in the Excel newsgroup:
news://msnews.microsoft.com/microsoft.public.excel

--
Carey Frisch
Microsoft MVP
Windows - Shell/User
Microsoft Community Newsgroups
news://msnews.microsoft.com/

-------------------------------------------------------------------------------------------

:

| We have an excel sheet that is quite complex. We have a chart that is linked
| to several cell containing results of a bunch of calculations. When we
| chnage parameters in those series the calculations are updated but the chart
| will not contain the changed data until we shut down the sheet and reopen
| it. We would like it to update in real time. Any ideas?
|
| Jason
 
Top