Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Chart Update While Macro Is Running
I've written a VBA macro that performs repetetive calculations in an Excel
worksheet. Data from the spreadsheet is displayed in an embedded chart (X-Y Scatter Plot). I want to watch the chart update while the macro runs. In Excel 2003 the macro works as intended. In Excel 2007 I see data in the spreadsheet updating but the chart does not. I'm running on two different office PCs, Windows XP installed on both, Office 2003 on one, Office 2007 on the other. I've tried both .xls and .xlsm file formats on the Office 2007 machine with the same result. I added a .Chart.Refresh line to my code, but still no joy (the macro runs, but the chart doesn't update until execution ends). Can't seem to find any pertinent help. Any suggestions (other than to try persuading my company it ought to revert back to Office 2003)? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL 2007 CHART REFRESH WHILE MACRO IS RUNNING | Charts and Charting in Excel | |||
Excel 2007 Chart auto update not working | Charts and Charting in Excel | |||
Excel 2007 does not update chart data | Charts and Charting in Excel | |||
Excel 2007 - chart data update loses legend | Charts and Charting in Excel | |||
Excel-Macro running through SQL update. | Excel Programming |