Side scroll nonfunctional (NOT scroll lock)

%3CLINGO-SUB%20id%3D%22lingo-sub-2492167%22%20slang%3D%22en-US%22%3ESide%20scroll%20nonfunctional%20(NOT%20scroll%20lock)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2492167%22%20slang%3D%22en-US%22%3E%3CP%3EI%20run%20very%20large%20reports%20that%20I%20then%20filter%20to%20pull%20up%20records%20for%20specific%20clients.%26nbsp%3B%20Most%20of%20the%20time%20that's%20fine%2C%20but%20every%20once%20in%20a%20while%20when%20I%20filter%20for%20some%20random%20name%2C%20the%20page%20becomes%20inert%2C%20the%20scroll%20bar%20is%20permanently%20at%20the%20bottom%2C%20and%20I%20can't%20get%20the%20sheet%20to%20give%20up%20any%20information%20therein%20contained.%26nbsp%3B%20I%20have%20to%20run%20the%20whole%20report%20again%20to%20access%20that%20client's%20information.%26nbsp%3B%20This%20happens%20completely%20randomly%26nbsp%3B%20This%20is%20NOT%20scroll%20lock.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2492167%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2492259%22%20slang%3D%22de-DE%22%3ESubject%3A%20Side%20scroll%20nonfunctional%20(NOT%20scroll%20lock)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2492259%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F147991%22%20target%3D%22_blank%22%3E%40Carol%20Kaminski%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20I%20recommend%20that%20you%20perform%20a%20Windows%20and%20Office%20update%20before%20starting%20anything%20else.%3CBR%20%2F%3EIt%20would%20be%20best%20if%20you%20insert%20a%20file%20(without%20sensitive%20data)%20where%20the%20problem%20occurs.%3CBR%20%2F%3EOn%20the%20basis%20of%20this%20file%2C%20explain%20when%20and%20under%20what%20name%20the%20file%20%2F%20worksheet%20is%20stuck.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20far%20as%20I%20have%20read%2C%20there%20was%20such%20a%20bug%20in%20Windows%20version%201709%20(i%20think%2C%20not%20sure)%2C%20but%20it%20has%20been%20corrected.%20But%20it%20was%20for%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fofficeupdates%2Fsemi-annual-enterprise-channel-preview-archived%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EWindows%20Enterprise%20Version.%3C%2FA%3E%3C%2FP%3E%3CP%3EFixed%20an%20issue%20where%20Excel%20might%20become%20unresponsive%20after%20using%20CTRL%20%2B%20SHIFT%20%2B%20arrow%20keys%20to%20scroll%20when%20sharing%20the%20Excel%20window%20through%20Microsoft%20Teams.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I run very large reports that I then filter to pull up records for specific clients.  Most of the time that's fine, but every once in a while when I filter for some random name, the page becomes inert, the scroll bar is permanently at the bottom, and I can't get the sheet to give up any information therein contained.  I have to run the whole report again to access that client's information.  This happens completely randomly  This is NOT scroll lock.

1 Reply

@Carol Kaminski 

With your permission, I recommend that you perform a Windows and Office update before starting anything else.
It would be best if you insert a file (without sensitive data) where the problem occurs.
On the basis of this file, explain when and under what name the file / worksheet is stuck.

 

As far as I have read, there was such a bug in Windows version 1709 (i think, not sure), but it has been corrected. But it was for Windows Enterprise Version.

Fixed an issue where Excel might become unresponsive after using CTRL + SHIFT + arrow keys to scroll when sharing the Excel window through Microsoft Teams.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)