Hi All,
I have attached the document in question. The issue I am having is when I edit a yellow cell in any "Input" sheet (marked in green), all the cells from other sheets that change end up overlayed on top of my data entry. This is clearly a visual glitch because if you scroll down the page and back up again, the problem is gone.
However, I know there must be something specific I have done in this case as I have another spreadsheet with around 15,000 lines of code and hundreds of sheets which does not have this issue.
I noticed there is a post with the same issue from 2016, but I tried Hui's recommendation, to no avail. Anyone have any tips? My work colleague opened it and also found the same issue, so I'm hoping you can see for yourselves when you open the file.
Any help would be greatly appreciated.
Thanks,
James
The post from 2016:
I have attached the document in question. The issue I am having is when I edit a yellow cell in any "Input" sheet (marked in green), all the cells from other sheets that change end up overlayed on top of my data entry. This is clearly a visual glitch because if you scroll down the page and back up again, the problem is gone.
However, I know there must be something specific I have done in this case as I have another spreadsheet with around 15,000 lines of code and hundreds of sheets which does not have this issue.
I noticed there is a post with the same issue from 2016, but I tried Hui's recommendation, to no avail. Anyone have any tips? My work colleague opened it and also found the same issue, so I'm hoping you can see for yourselves when you open the file.
Any help would be greatly appreciated.
Thanks,
James
The post from 2016:
Excel glitch. Cells from other sheets appearing on top of current sheet
Hi, Can anyone help with the following glitch. Whenever I enter data in one sheet, the row from a summary sheet which has formulas linking back to this sheet is displayed which is very annoying (see overlay on row 16 and also row 10). I have quite a bit of code in the sheet but I don't this...
chandoo.org
Attachments
-
391.3 KB Views: 4