+ Reply to Thread
Results 1 to 2 of 2

Chart updating problem

  1. #1
    Registered User
    Join Date
    11-17-2010
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    1

    Chart updating problem

    I have a spreadsheet for option modeling. Auto recalc of the spreadsheet is disabled. It has 2 macros that we are concerned with.

    Macro A
    gets data from a remote source, and then waits for the data download to complete. This updates a bunch of cells on the spreadsheet. This data is NOT charted. After data download is completed, (after receiving a callback from the remote source) it calls Macro B. This updates more cells in the worksheet, which is the source data for the chart. This fails to update the chart based on new values. Even hitting F9 doesn't help

    Macro B
    However, if I run this macro directly (from a hotkey), it updates the chart with new values.

    Any idea why this is so and what needs to be done done to fix the problem? Manually running Macro B is inconvenient. Thanks!

    Edit: Using Excel 2007 in xp 32 bit
    Last edited by deyab; 11-24-2010 at 04:47 PM. Reason: added excel version

  2. #2
    Registered User
    Join Date
    11-22-2010
    Location
    Finland
    MS-Off Ver
    Excel 2003, 2007
    Posts
    95

    Re: Chart updating problem

    Could you paste the line(s) where Macro B is called and few lines around it.

    Of course an entire example file would be the best
    An example file is never useless!

    Tried an example function of mine and got errors?
    - Had you found them, replace ; with , and , with .

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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