PDA

View Full Version : 2007 Chart not updating



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

Bob Phillips
09-10-2009, 09:47 AM
What do Macro1, 2, 3 and 4 do?

JimS
09-10-2009, 09:57 AM
Macro1: Runs Macro2 and Macro3 and then copies any Active Project data from the Project Data sheet to the hidden Timeline Data sheet and then runs Macro4.

Macro2: Alerts the user if they have an Active Project but did not enter a Estimated Completion Date on the Project Data sheet.

Macro3: Deletes/clears any data on the Timeline Data sheet before the Active Project Data gets copied over to it.

Macro4: Enters a formula on the Timeline Data sheet for each entry that was copied over from the Project Data sheet.

Macro5: Sorts the Timeline Data sheet in Date Order.

Paul_Hossler
09-10-2009, 03:06 PM
If I turn on automatic calc under Options, update some to Active, and go to the chart, it seems to be updated

Paul

JimS
09-10-2009, 04:12 PM
I have Calculate set to Automatic and it still fails...

JimS
09-11-2009, 06:04 PM
Was anyone able to reproduce this isssue when using the attachment in 2007 or is it just my Excel?

JimS

Bob Phillips
09-12-2009, 07:16 AM
I reproduced it, but I have not tracked it down yet.

JimS
09-17-2009, 06:07 PM
xld,

Any ideas yet?

JimS

JimS
10-01-2009, 10:57 AM
Does anyone have any ideas on this one?

Thanks...

JimS