Hi,
I've received email today from one of my colleague, more less like:
"Could you take a look on sheet X.
Is always hidden, calculates properly, but I need to change some parameters for next year and I can't working comfortably with it.
Terrible interruption while scroll with scrollbar or using arrow / pageUp /pageDown....."
I've opened this sheet and indeed scrolling was practically impossible.
Data were spread around A1:BM800, so small bunch of. I've check used range, was quite matching. No weird formulas, couple of errors on results.... but nothing explained this behaviour.
After some time (I have no idea what to check), I've spot that data are so colourful and try to check CF setting..... When I was trying to open CF rules manager, I was waiting around 45 seconds to display it!!
So I've used VBA:
and quick contest how many CF rules have been set?Please Login or Register to view this content.
Bookmarks