JimS
09-10-2009, 09:19 AM
I have a workbook that was created in 2003 and works perfectly.
My 2007 users are having troubles getting the Chart to update automatically.
I have included a sample workbook (2007 Excel Macro-Enabled Workbook).
Here's what the issue is:
Data is entered on the Project Data sheet and if a Project Status is Active it will be placed on the Timeline chart (via the data being copied to the Timeline Data sheet by a Macro).
If you change a few of the Project Statuses on the Project Data sheet to Active and then go directly to the Timeline (chart sheet) the chart does not update.
But if you change some project statuses to Active and scroll through all the other worksheets before opening the Timeline Chart sheet then the Chart updates automatically.
Any ideas as to why the chart will not update if you go directly to it after changing a status on the Project Data sheet?
Thanks for any and all help...
JimS
My 2007 users are having troubles getting the Chart to update automatically.
I have included a sample workbook (2007 Excel Macro-Enabled Workbook).
Here's what the issue is:
Data is entered on the Project Data sheet and if a Project Status is Active it will be placed on the Timeline chart (via the data being copied to the Timeline Data sheet by a Macro).
If you change a few of the Project Statuses on the Project Data sheet to Active and then go directly to the Timeline (chart sheet) the chart does not update.
But if you change some project statuses to Active and scroll through all the other worksheets before opening the Timeline Chart sheet then the Chart updates automatically.
Any ideas as to why the chart will not update if you go directly to it after changing a status on the Project Data sheet?
Thanks for any and all help...
JimS