Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
No Charts will refresh in a Workbook
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
No Charts will refresh in a Workbook
Thanks for your response Tom. However, i don't believe this is the problem because every single chart in the workbook is unresponsive to any change in the underlying data. It is only happening in this workbook. When i run a copy of the same workbook it's fine. In a new instance of Excel it's also fine. It has to be something to do with this workbook that seems to be turning off the Charts. I'm at a loss and getting to desparation stage. Regards, Ric *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Charts slow to refresh | Charts and Charting in Excel | |||
Force charts to refresh? | Charts and Charting in Excel | |||
Refresh pivot table in workbook A when changing a cell in workbook | Excel Worksheet Functions | |||
Large spreadsheet - Charts don't refresh | Charts and Charting in Excel | |||
Refresh queries, graphs, and charts | Excel Discussion (Misc queries) |