logo elektroda
logo elektroda
X
logo elektroda

[Excel 2013] Non-Functional Sheet Side Scroll Bar: Navigation in Worksheet with Thousands of Lines

pegazik1 14922 2
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
  • #1 15553843
    pegazik1
    Level 12  
    Hello
    I have a strange problem with the file. Sheet side scroll bar does not work. The bottom bar (right / left) works without a problem. The worksheet contains several thousand lines and it is now virtually impossible to navigate through it. Since the file is used by a large number of people, I suspect that someone has blocked something, but now I don't know how to unlock it :)
    Maybe some of you had a similar case?
  • ADVERTISEMENT
  • #2 15553860
    Templarious
    Level 22  
    Launch windows updates, download and install.

    or

    "Safe Mode allows you to safely use Excel without encountering some startup programs. You can open Excel in Safe Mode by pressing and holding the Ctrl key while starting the program, or by using the / safe" (i.e. excel.exe / safe) option when starting the program from the command line . When you start Excel in safe mode, it bypasses features and settings such as alternative startup location, altered toolbars, xlstart folder, and Excel add ins. (however, COM add-ins are disabled.) "

    Let me know.
  • #3 15553964
    pegazik1
    Level 12  
    I'm stupid - it's probably during this holiday season. The file is password protected against editing. Only some editable columns are provided. Yet someone just blocked the windows :) I thought it was blocked. A simple thing, and it confused me.
    Thanks for the advice.
    I greet and wish you a happy Christmas
ADVERTISEMENT