The issue I am having is getting the graphs to update when I run a macro that redefines the range. Everything works fine in Office 2000 but not in Office 2003.
I have a file that contains multiple sheets:
Data sheets = there are many of these which all contain the same rows and columns but contain different data
"First" and "Last" sheets = sheets used to define data ranges
"Summary" Sheet = a sheet that contains a summary of data from the multiple data sheets, on this sheet the cells read from the "First" sheet to the "Last" sheet (hope that makes sense)
"Graphs" sheet = contains multiple graphs that read from the "Summary" Sheet, this sheet also contains a drop down menu that contains the individual names of the data sheets and a button that runs a macro
So the user selects from the drop down menu the data they want to see then runs the macro. The macro then places the "first" sheet in front of the data sheet (selected from the dropdown menu) and the "Last" sheet after it. So the summary sheet then reads from the selected data sheet and the graphs read that data.
In Office 2003, the macro runs fine and the first time it is run the graphs are correct. The second time it is run, the macro runs fine and the data on the summary sheet is updated correctly. However the graphs do not change. The cells they are reading from contain different data but it is like the graphs do not recognize it and hold the data that was previsouly there. If I were to close the file, save changes, and re-open, the graphs refresh and are correct.
This is hot happening in Office 2000, so is there something I need to do in Office 2003 to refresh the graphs? Could it be that Office 2003 was not installed properly?
I have a file that contains multiple sheets:
Data sheets = there are many of these which all contain the same rows and columns but contain different data
"First" and "Last" sheets = sheets used to define data ranges
"Summary" Sheet = a sheet that contains a summary of data from the multiple data sheets, on this sheet the cells read from the "First" sheet to the "Last" sheet (hope that makes sense)
"Graphs" sheet = contains multiple graphs that read from the "Summary" Sheet, this sheet also contains a drop down menu that contains the individual names of the data sheets and a button that runs a macro
So the user selects from the drop down menu the data they want to see then runs the macro. The macro then places the "first" sheet in front of the data sheet (selected from the dropdown menu) and the "Last" sheet after it. So the summary sheet then reads from the selected data sheet and the graphs read that data.
In Office 2003, the macro runs fine and the first time it is run the graphs are correct. The second time it is run, the macro runs fine and the data on the summary sheet is updated correctly. However the graphs do not change. The cells they are reading from contain different data but it is like the graphs do not recognize it and hold the data that was previsouly there. If I were to close the file, save changes, and re-open, the graphs refresh and are correct.
This is hot happening in Office 2000, so is there something I need to do in Office 2003 to refresh the graphs? Could it be that Office 2003 was not installed properly?