Microsoft Update Excel 2013 (KB3085502) 32-Bit Edition causing issues in Excel
We are seeing strange results in Excel after the Sept 8, 2015 "Security Update for Microsoft Excel 2013 (KB3085502) 32-Bit Edition" update. When a vba macro changes the sheet, the formula bar does not change to the cell on the new sheet and it gets locked up. Then changing something in the formula bar changes the cell on a different sheet. There is a disconnect between the formula bar and cells. Uninstalling the update fixes every computer that we use.
This Microsoft update is causing problems that Microsoft needs to address.
This is Andrew Stegmaier, and I'm a Program Manager on the Excel engineering team.
I wanted to let everyone know that we're aware of issue, and we're working on a fix. It was an unexpected side-effect of a performance optimization that we shipped in this update. I apologize for the inconvenience that this has caused--we expect to ship the fix in the November public update. The best workarounds I can suggest in the meantime are:
1. Uninstall KB3085502
2. Manually switching between sheet tabs appears to fix things up in many cases
3. Calling ActiveCell.Select (as suggested by Inno210) can also fix things up in many cases.