Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I just started using Excel 2007 (on a separate machine, of course, in
case it is a disaster), and I am having problems with charts. In Excel 2003, it was possible to use an embedded scrollbar which is linked to a cell which changes the data underlying a chart. By default in Excel 2003, under automatic calculation the Chart would not refresh itself to display the updated data so long as you are still holding the mouse button down (like when you are dragging the scrollbar around, wishing to see updates in real-time). But you could fix this by putting a formula that depends on the linked cell in all the cells behind the chart. I have many applications that rely on this to be true. In Excel 2007, even doing the tricks above do not get the Chart to update in real-time. I have to release the mouse button to get it to update. This is terrible. Is there another trick I need to do to regain prior functionality? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Updating Problem with Large Excel File | Excel Discussion (Misc queries) | |||
Problem with updating links in Excel 2003 | Excel Worksheet Functions | |||
Problem with updating links in Excel 2003 | Excel Worksheet Functions | |||
Problem updating Excel using ado.net | Excel Programming | |||
Excel VBA - Updating of data problem | Excel Programming |