I have an issue with a users Excel book.
Its a shared workbook in a Citrix environment with three presentation servers and it's affecting 2/3 users and I don't know where the problem lies.
If a user filters by state, all happy, freeze panes still happen
when a user removes the filter, and selects all, then they can no-longer scroll and the freeze panes are affected.
The only way to fix it then is to remove the split and the freeze and then re-do it.
I've checked, and its not something simple like Scroll lock, and I've also tested scrolling all the way to the top to cell A1 and then removing the filter, but that still affects the freeze panes.
This is frustrating because despite showing the user what to do, he still comes and pesters me to fix it each time it happens.