View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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