locked
refresh excel chart during macro running, EXCEL 2016 RRS feed

  • Question

  •  My Macro supposes to update a chart step by step.  All is working well, but the chart is not refreshed but at the final stage (when the macro is over, or if BREAK is enforced).

    The project ran okay in older versions of EXCEL!

    Use of "REFRESH", "REFRESHALL", "CALCULATE", "SCREENUPDATE",...   does not help.

    Wednesday, February 10, 2016 12:07 AM

All replies

  • Did you solve this? The only way I have found to do this so far is to call ActiveSheet.ResetAllPageBreaks . But its very slow if you have to keep doing it.
    Monday, August 15, 2016 7:10 PM
  • Call DoEvents at the appropriate point to give Excel some time slice to do the work.

    Andreas.

    Tuesday, August 16, 2016 7:11 AM