Forum Discussion
Excel Macros Causing Display Glitches On Workbook with Multiple Pages and Formulas
Occasionally I try searching again for any new developments in this maddening glitch and this is still the only thread I find anywhere. I admin an Excel-based pricing tool loaded with macros, hidden sheets of reference data for lookups, and protected sheets that are essentially a UI for configuring a product to get a final price. Users think I'm screwing it up because of this! I've tried recreating entire sheets and It seems to help at first then reverts back after any additional changes.
It's an incredibly horrible glitch that mostly happens when a sheet is protected except for specific user-entry cells. Scrolling typically clears it. Switching back and forth between tabs always corrects it. I've resorted to adding a "screen refresh" button that calls a macro to do the tab flip. But when there can be 10-15 user interactions with each one triggering the glitch it's maddening for my users.
I tried digging into Office, Excel, and Windows settings for display, hardware acceleration, and literally anything else that could feasibly stop it but nothing has.
Occurs in ONLY one Excel workbook, no others, and not predictably consistent for the most part. Some sheets do it every time, others sometimes.