| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Scroll Bar Disappears
or doesn't work right when I use freeze panes. Maybe it is due to too many
tabs in my worksheet??? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Scroll Bar Disappears
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 On Thu, 24 Jul 2008 08:28:00 -0700, Lucy wrote: or doesn't work right when I use freeze panes. Maybe it is due to too many tabs in my worksheet??? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Scroll Bar Disappears
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??? "Gord Dibben" wrote: 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 On Thu, 24 Jul 2008 08:28:00 -0700, Lucy wrote: or doesn't work right when I use freeze panes. Maybe it is due to too many tabs in my worksheet??? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Scroll Bar Disappears
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 On Thu, 24 Jul 2008 15:17:00 -0700, Lucy wrote: 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??? "Gord Dibben" wrote: 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 On Thu, 24 Jul 2008 08:28:00 -0700, Lucy wrote: or doesn't work right when I use freeze panes. Maybe it is due to too many tabs in my worksheet??? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Scroll Bar Disappears
You were right...I closed some of the app's and it started working correctly.
Thanks! "Gord Dibben" wrote: 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 On Thu, 24 Jul 2008 15:17:00 -0700, Lucy wrote: 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??? "Gord Dibben" wrote: 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 On Thu, 24 Jul 2008 08:28:00 -0700, Lucy wrote: or doesn't work right when I use freeze panes. Maybe it is due to too many tabs in my worksheet??? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Scroll Bar Disappears
The 12-gauge works again.
Thanks for the feedback. Gord On Thu, 24 Jul 2008 18:54:03 -0700, Lucy wrote: You were right...I closed some of the app's and it started working correctly. Thanks! "Gord Dibben" wrote: 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 On Thu, 24 Jul 2008 15:17:00 -0700, Lucy wrote: 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??? "Gord Dibben" wrote: 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 On Thu, 24 Jul 2008 08:28:00 -0700, Lucy wrote: or doesn't work right when I use freeze panes. Maybe it is due to too many tabs in my worksheet??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Horizontal-Scroll Navigation Bar Intermittently Disappears | Excel Discussion (Misc queries) | |||
| Every time I scroll up or down, my picture disappears | Excel Discussion (Misc queries) | |||
| my excel spreadsheet right scroll button disappears during use | Excel Discussion (Misc queries) | |||
| Scroll horizontaly with mouse, create same system used to scroll . | New Users to Excel | |||
| scroll bar on chart disappears | Charts and Charting in Excel | |||
Hybrid Mode
