Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
EXCEL 2007 CHART REFRESH 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 convince my company to revert back to Office 2003)? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
EXCEL 2007 CHART REFRESH WHILE MACRO IS RUNNING
See the replies to your post in .programming.
-- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu "MikeM" wrote: 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 convince my company to revert back to Office 2003)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I refresh in excel 2007 a 2003 pivot table? | Excel Discussion (Misc queries) | |||
Pivot Chart won't refresh in Excel 2007 | Charts and Charting in Excel | |||
Create macro to calculate data range for a running chart | Excel Worksheet Functions | |||
Running a macro from an auto-refresh | Excel Worksheet Functions | |||
Excel 2007 Refresh Pivot Table | Excel Discussion (Misc queries) |