Actually,
Tushar, I did find something...
http://support.microsoft.com/kb/821644/en-us
XL2002: Charts Do Not Update When Source Cells Are Updated
will give this a try...
Thanks again..
On Feb 2, 12:59 pm, Tushar Mehta <tmUnderscore200...@tushar-
mehta.SeeOhEm wrote:
Someone else may have a more definitive answer but...
Searched support.microsoft.com? I just did with the keywords 'excel chart
does not update' (w/o the quotes) and got several hits. Of course, I don't
know if any applies to your problem.
--
Regards,
Tushar Mehtahttp://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
"nandan" wrote:
I apologize in advance, because i know there are a lot of similar
posts.
None, as far as i can tell , have a definitive answer as to how this
was fixed.
I have written and addin with a number of custom formulas.
A client has a spreadsheet that gets data from these formulas,
performs simple calculations on it (like determines a percentage) and
uses a range of these values to populate a chart.
When i recalculate the spreadsheet, all the formulas are recalculated
(I use xlc SendKeys CNTRL-ALT-F9) to calculate the data.
However the graph/chart is not refreshed.
I believe this is an Excel bug because
(1) If i save the spreadsheet and reopen it, then the chart is
updated !!
(2) If i simply "delete" an empty row in the spreadsheet, the chart is
updated !!! (go figure). I think i remember reading somewhere that
hiding / deleting rows causes Excel to recalculate or something, but i
maybe wrong.
Is there a non-kludgy way to force the chart to update?
OR
Is there a less kludgy way to force the chart to refresh? (than always
deleting an empty row, and undeleting it - I'm assuming there is a way
to do that programmatically)
How has everyone else handled this ?
Thank you for your response and time.- Hide quoted text -
- Show quoted text -