+ Reply to Thread
Results 1 to 3 of 3

Chart not updated until chart sheet opened following source data update

  1. #1
    Registered User
    Join Date
    09-23-2013
    Location
    shenzhen, china
    MS-Off Ver
    Excel 2007
    Posts
    2

    Chart not updated until chart sheet opened following source data update

    Hello. I'm using excel 2007. There're several sheets containing lots of charts drew from data quoted from a same sheet in the same book. Since the charts in the sheets are quite many each time I update the original data and click another sheet open I have to wait a second before the charts in that sheet all complete their automatical update. Thus It's quite inconvenient that with each sheet I have to wait a second before I'm able to see the update result. Any ideas to get all the sheets update the charts in them before clicking them open? Thanks a lot!
    Last edited by 6StringJazzer; 09-24-2013 at 08:23 AM. Reason: Better thread title

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,576

    Re: about data update

    Welcome to the Forum!

    I appreciate that English may not be your first language so I'm going to update your thread title to something more descriptive. Almost every thread in this forum is related to data updates of some kind.

    In the meantime, please take the time to review our rules. There aren't many, and they are all important. Rule 1 is about thread titles.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    09-23-2013
    Location
    shenzhen, china
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: about data update

    Quote Originally Posted by 6StringJazzer View Post
    Welcome to the Forum!

    I appreciate that English may not be your first language so I'm going to update your thread title to something more descriptive. Almost every thread in this forum is related to data updates of some kind.

    In the meantime, please take the time to review our rules. There aren't many, and they are all important. Rule 1 is about thread titles.
    Thanks very much! I appreciate it!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Userform enter data/update data/delete data
    By msaleh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-29-2014, 12:18 PM
  2. Automatically update existing data using a Update command button
    By 9999335 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2012, 09:46 PM
  3. Charting file template to clear old data, paste new data and update chart
    By cwilliams321 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-29-2012, 04:13 PM
  4. *UPDATE* Rows of data to Columns of data *UPDATE*
    By a6ela in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-04-2010, 11:30 AM
  5. [SOLVED] how to update data on sheet1 and have it auto update on sheet2
    By Tommy in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-11-2005, 06:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1