SOLVED

Excel sheet not Scrolling

%3CLINGO-SUB%20id%3D%22lingo-sub-2755524%22%20slang%3D%22en-US%22%3EExcel%20sheet%20not%20Scrolling%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2755524%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Excelers%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20I%20am%20facing%20a%20scrolling%20issue%20in%20a%20particular%20sheet.%20This%20sheet%20doesn't%20scroll%20with%20the%20mouse%20(but%20scrolls%20with%20arrow%20keys)%20although%20all%20other%20sheets%20in%20the%20workbook%20are%20functioning%20as%20usual.%20Only%20the%20%22sizing%22%20sheet%20seems%20to%20have%20this%20issue.%20There%20are%20a%20lot%20of%20linked%20data%20in%20the%20%22sizing%22%20sheet.%20Can%20someone%20help%20me%20out%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENB%3A%20For%20security%2C%20I%20have%20wiped%20out%20all%20the%20data%20and%20kept%20the%20sheets%20only.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ESandip%20Gumtya%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2755524%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2757255%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sheet%20not%20Scrolling%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2757255%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F677557%22%20target%3D%22_blank%22%3E%40sandipgumtya365%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHmm...%20I%20have%20no%20problem%20scrolling%20the%20sizing%20sheet%20with%20the%20mouse.%3C%2FP%3E%0A%3CP%3EDoes%20the%20problem%20persist%20if%20you%20completely%20quit%20Excel%20then%20reopen%20the%20workbook%3F%3C%2FP%3E%0A%3CP%3EIf%20so%2C%20does%20it%20persist%20if%20you%20restart%20your%20computer%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2757382%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20sheet%20not%20Scrolling%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2757382%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3Bthanks%20for%20your%20reply.%20Yes%2C%20I%20have%20tried%20to%20use%20the%20same%20file%20in%20a%20different%20system%20but%20I%20am%20facing%20the%20same%20issue.%20Are%20you%20able%20to%20scroll%20all%20three%20sheets%20with%20the%20mouse%3F%26nbsp%3B%20If%20so%2C%20what%20might%20be%20the%20issue%20at%20my%20end%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESandip.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Dear Excelers,

                      I am facing a scrolling issue in a particular sheet. This sheet doesn't scroll with the mouse (but scrolls with arrow keys) although all other sheets in the workbook are functioning as usual. Only the "sizing" sheet seems to have this issue. There are a lot of linked data in the "sizing" sheet. Can someone help me out?

 

NB: For security, I have wiped out all the data and kept the sheets only.

 

Thanks

Sandip Gumtya

 

6 Replies

@sandipgumtya365 

Hmm... I have no problem scrolling the sizing sheet with the mouse.

Does the problem persist if you completely quit Excel then reopen the workbook?

If so, does it persist if you restart your computer?

Hi @Hans Vogelaar thanks for your reply. Yes, I have tried to use the same file in a different system but I am facing the same issue. Are you able to scroll all three sheets with the mouse?  If so, what might be the issue at my end?

 

 

Sandip.

@sandipgumtya365 

Yes, I can scroll all sheets in that workbook with the mouse.

I have also looked at the properties of the sheets in the Visual Basic Editor and didn't find anything special. So I have no explanation for the behavior that you experience, sorry.

best response confirmed by sandipgumtya365 (Contributor)
Solution

@sandipgumtya365 

If scrolling by mouse means scrolling by mouse wheel staying on any cell, not clicking by mouse on scroll bar - yes, it doesn't work in my case as well.

 

In 'sizing' sheet rows starting from 9000 or so till end are hided. If unhide them mouse wheel scrolling works, please check in attached. Not sure what is behind this effect.

Hi @Sergei Baklan ,

                               Unhiding the rows from 9000 did the trick but still unclear what was causing this. Anyway, thanks for your inputs.

 

Thanks

Sandip.

 

@sandipgumtya365 , you are welcome. I can't reproduce that on new file and not sure what's the reason exactly, will try to investigate some later.