Upgraded to 2016: Graphs are no longer animated running VBA

JetEscamilla

Board Regular
Joined
Apr 17, 2006
Messages
89
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!
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

John_w

MrExcel MVP
Joined
Oct 15, 2007
Messages
6,123
Try activating the chart object:
Code:
ActiveSheet.ChartObjects("Chart 1").Activate
 

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,755
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?
 

Forum statistics

Threads
1,089,228
Messages
5,406,998
Members
403,117
Latest member
redblasko

This Week's Hot Topics

Top