Excel Display acting funny....!

[Jason Barnes]

If I have Sheet1 and Sheet2.
Sheet1 has a formula in cell A1 that sums from cells on sheet 2.
If I'm on Sheet2 and change a value in a cell...

• (therefore the value of A1 on Sheet1 changes)

... A1 on Sheet1 shows through on Sheet2. like a glitch or something
I have to scroll down till it runs off page, then scroll back up.

Causes? Fixes?

Jason

 

[Jason Barnes]

Just refreshing this back to the top in hopes someone understands the issue.
It's when a formulas calculation on a different page changes, it shows through on my current page until I refresh it,
(minimize and restore, scroll down past the glitch the back up)

Thanks,
Jason

 

[Teeroy]

Have you been running any VBA Macros? This can happen if a macro sets Application.Screenupdating = False and crashes before setting Application.Screenupdating = True. If this is the case the just copy "Application.Screenupdating = True" in the VBE Immediate window and hit enter and the problem should resolve.

 

[Jason Barnes]

thanks, that makes since, I will check all my codes for each sheet and see if I left it out.