Forum Discussion
Excel Macros Causing Display Glitches On Workbook with Multiple Pages and Formulas
Hello,
I'm hoping someone can help me out here. I have seen a post with similar issues that was resolved, however, I tried the solution (turning on and off screen updating for the macros). The macros I am running are quite simple. Basically just unhiding and hiding sheets so that the user of the workbook doesnt have to type in a password to lock and unlock the workbook each time he needs to add more pages or remove unused pages.
There are a lot of formulas that pull data from other areas of the workbook (Xlookup, Count, IF/And, Stuff like that) and what seems to be happening is on most pages when data is entered the active sheet becomes see through in random cells showing the next page. When I scroll down and up the sheet goes back to normal. For me it isn't an issue, however, I will be submitting this reporting template to a client multiple times and it would be nice if the workbook was working as intended. Please note that the example photos below are only one example. This issue happens on basically every page of the workbook.
Here is what a sheet looks like prior to accessing the page when has the data on it that will fill this page (The blue cells are formula cells that pull data from the next page:
Here is the upload page where I will add data that will get uploaded to the page above (You can see the issue in this photo):
Here is what the page should look like:
- I find that a manual page-down and page-up usually fixes the display issue. So you could add this:
ActiveWindow.LargeScroll Down:=1
ActiveWindow.LargeScroll Down:=-1- Thank you for taking the time to respond! This would work I would imagine as i simply scroll down then up to refresh the page, however, this issue is not something that happens when the page opens up. It only happens when i enter data into a cell. Example: I click the button to open the page i desire, everything looks good, and then i enter data into a cell, everything still looks good, and then when i hit enter or anything else to have the data officially input into that cell that is when the display goes all wonky. so i would need to scroll down and up every time i enter data into any cell on the given page.
- Hmm. Perhaps you should click Help, Feedback and tell them something's wrong. Make sure you include a screenshot of the issue.
- thanks for the option but it didnt solve the issue unfortunately
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.
