| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
My graphs no longer refresh w/new data, why? auto calc is on.
I have a very large excel file in Office 2003 and something happened to cause
the file to stop refreshing the graphs when the underlying data is changed. I have verified that auto calc is set to on and my calculations do refresh. The only way to get the graphs to refresh is to save the file, close it and reopen it. An interesting side note: If I open this file in the new Office 2007 the graphs work fine in compatibility mode. the file is originally a 2003 file and it broke in the 2003 envirnoment but again, it works fine in Office 2007 compat mode. Strange! Ideas?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I auto-refresh auto-filters when data changes? | Excel Worksheet Functions | |||
| How can I eliminate the auto refresh chart when data is imported? | Excel Discussion (Misc queries) | |||
| auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
| How Do I Automatically Refresh Auto Filtered Data? | Excel Discussion (Misc queries) | |||
| How to auto-refresh Pivot data when open Excel file? | Excel Worksheet Functions | |||
Linear Mode
