Charts do not update
Jon Peltier
My workbook has some ranges that update whenever the worksheet recalculates,
because their formulas include RAND(). There are a number of worksheet-level
complex named ranges, and only one chart. The chart has only around 8 series,
but some of them have data labels linked to worksheet cells, and these cells
have formulas like ="UCLx="&TEXT(A1,"0.00"). There's also a worksheet_change
procedure that adjusts the chart axis scales. The only thing that doesn't
update in the entire worksheet and chart are these data labels. If I select
each label, click in the formula bar, and press Enter, the label updates, but
then it retains this value until I repeat the manual update procedure.
I've often answered these posts with reminders to set calculation to
Automatic, and basic things like that. Later today I will build a new copy
of this workbook to see if that helps. If anyone has come across a more
profound solution, please post it.
Thanks,
- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
In article <1ff9601c297f6$403417e0$89f82ecf@TK2MSFTNGXA01>,
ggorc...@golder.com says...
>
>Thank you Jon. I tried it with all possible settings. I
>think it is not a problem with any of my settings but a
>glitch in Excel or the file itself. Eventually I wrote a
>macro that "confirms" data ranges of all the charts in the
>file and that makes them refresh. So, I worked around the
>problem but still don't know what caused it ;)
>
>George
>
>>-----Original Message-----
>>George -
>>
>>Go to Tools menu - Options - Calculation tab. Make sure
>Calculation is set
>>for Automatic.
>>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>http://www.geocities.com/jonpeltier/Excel/index.html
>>_______
>>
>>In article <1d4ca01c2970d$3ecf7eb0
>$8af82ecf@TK2MSFTNGXA03>, George said...
>>>
>>>Hi All,
>>>
>>>I have a spreadsheet with complex calculations (lots of
>IF
>>>statements). It's about 30 columns and 9000 rows. There
>is
>>>a bunch of charts displaying results of calculations.
>>>There are no macros or external links.
>>>
>>>I added 16 more columns with calculations and 4 new
>charts
>>>based on these new calcs. Once I did that, the charts
>>>stopped updating (not only the new ones but the ones
>>>already in the file, that were updating before). By
>>>updating I mean, after I change my input values and
>>>recalculate the spreadsheet, charts stay with old
>values.
>>>But if I change data source range for the chart, even by
>1
>>>cell, it updates.
>>>
>>>Any idea why I lost automatic updates? I will appreciate
>>>any help.
>>>
>>>Regards
>>
>>.
>>
Glen Millar
Forgive me from wandering away from PowerPoint, but does this help?
kbbug KB186461
Else, there is another on I will chase up that I know of as it happened
here. It more is more general to XL.
--
Regards,
Glen Millar
http://www4.tpg.com.au/millarg/index.html
"Jon Peltier" <jonpe...@yahoo.com> wrote in message
news:OxtTSJgmCHA.2300@tkmsftngp07...
Jon Peltier
Hey, thanks for stopping by. 186461 didn't apply, but while checking it out I
also input my own keywords and found this article that described the problem
exactly:
XL97: Chart Data Labels That Are Linked to Formulas Are Not Updated
http://support.microsoft.com/default.aspx?scid=kb;en-us;182999
It's supposed to have been fixed in xl97-sr2, but that's what I'm running.
But the article assures me that Ctrl-Alt-F9 will force a total update.
We shouldn't feel bad about spending time in each others' news group. We can
learn and help each other, while we smash cultural barriers and all that happy
nonsense. I'm glad to accept help from wherever it is available.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
In article <aWTG9.225$_27....@news.optus.net.au>, mil...@tpg.com.au says...