Upgraded to 2016: Graphs are no longer animated running VBA

[JetEscamilla]

Hello, I did some searching but could not find anything that seemed to work for me so I apologize if this has been asked before:

Our office recently did a batch of Windows upgrades and I'm now on Excel 2016. I have numerous macros that will perform iterations and update numbers on the screen. Those numbers create some graphs that used to update. This was handy because we could see at what step (approximately) something ruptured. Now when I run the same macro only the numbers are updating, the charts stay frozen until the end of the run.

I've tried inserting some chart updating directly into my code, but that's not working either.

"ActiveSheet.ChartObjects("Chart 1").Chart.Refresh"

I've ensured that screedupdating was "true".

Like I said, the numbers update but the graphs are not. I'd honestly rather have that flipped, graphs only and I don't care for the numbers to update.

I appreciate any help.

Thanks!

 

[John_w]

Try activating the chart object:

ActiveSheet.ChartObjects("Chart 1").Activate

 

[Jon Peltier]

It would be helpful if you shared some actual code, that used to work but no longer does.

Also, what version of Excel were you using when the code worked?