LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Excel 2007Chart updating problem

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating Problem with Large Excel File TonyKA Excel Discussion (Misc queries) 3 June 2nd 09 05:39 PM
Problem with updating links in Excel 2003 Mike Gallof Excel Worksheet Functions 1 October 14th 05 05:17 PM
Problem with updating links in Excel 2003 Mike Gallof Excel Worksheet Functions 0 October 14th 05 04:39 PM
Problem updating Excel using ado.net Lisa[_11_] Excel Programming 4 July 29th 04 03:54 PM
Excel VBA - Updating of data problem teyhuiyi[_2_] Excel Programming 2 April 19th 04 10:38 AM


All times are GMT +1. The time now is 09:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"