Sadly changes made in vba not updating in show view can be a problem. Are you using the latest version of Office? (It was more prevalent in earlier versions) Also mixing vba and animation can cause this.