No Charts will refresh in a Workbook
Maybe the source data got changed accidentaly. (if you highlight the
formula and hit F9, then enter, it becomes hardcoded as the values, rather
than a range, as an example).
--
Regards,
Tom Ogilvy
"Ric Payne" wrote in message
om...
I have an application that has many charts on many sheets. I have
just discovered that in 2 versions of this workbook none of the charts
will refresh when I change the Source Data.
In other versions of exactly the same application the refreshing works
just fine.
Is there something at the workbook evel that turns off chart
refreshing?
Your help will be most appreciated.
Regards,
Ric Payne
|