 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / July 2008Scroll Bar Disappears
or doesn't work right when I use freeze panes. Maybe it is due to too many tabs in my worksheet??? Which scroll bar? Vertical or horizontal? Too many sheet tabs in your workbook should have nothing to do with the scroll bars although you can drag the horizontal bar so far to the right it becomes invisible. Drag it back to the left. Freeze Panes should not affect either scroll bar. Gord Dibben MS Excel MVP >or doesn't work right when I use freeze panes. Maybe it is due to too many >tabs in my worksheet??? It is the horizontal scroll bar. It is acting erratically. There are 24 tabs in my workbook, and it works fine on 23 of them. The worksheet that isn't working properly is very large with a variety of long formulas. There are about 40 columns on the worksheet. The scroll bar works normally, but as soon as I do a freeze pane it changes. It doesn't really disappear completely, it has the left arrow and the bar, but no right arrow. When I click on the bar, it does nothing except scramble the appearance of the bar. (The right arrow turns into a series of lines that resemble bar codes, and the bar does not function at all.) Then when i click 'unfreeze panes' it magically comes back. I've tried dragging it around, but that only scrambles the appearance more. Any thoughts??? > Which scroll bar? > [quoted text clipped - 12 lines] > >or doesn't work right when I use freeze panes. Maybe it is due to too many > >tabs in my worksheet??? Can't say I've ever run into this. Sounds more like a Resource issue. Shot-gunning now<g> Freezing Panes should not cause a re-calc of the workbook but have you tried with calculations set to manual? What else is running? Can you close out a few running applications to free up some resources? Gord >It is the horizontal scroll bar. It is acting erratically. There are 24 >tabs in my workbook, and it works fine on 23 of them. The worksheet that [quoted text clipped - 24 lines] >> >or doesn't work right when I use freeze panes. Maybe it is due to too many >> >tabs in my worksheet??? You were right...I closed some of the app's and it started working correctly. Thanks! > Can't say I've ever run into this. > [quoted text clipped - 39 lines] > >> >or doesn't work right when I use freeze panes. Maybe it is due to too many > >> >tabs in my worksheet??? The 12-gauge works again. Thanks for the feedback. Gord >You were right...I closed some of the app's and it started working correctly. > Thanks! [quoted text clipped - 42 lines] >> >> >or doesn't work right when I use freeze panes. Maybe it is due to too many >> >> >tabs in my worksheet??? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.