tshaffer03
New Member
- Joined
- Jul 7, 2003
- Messages
- 12
A workbook is set up as shared.
Row 1 (the column headers) is frozen with Windows/Freeze Panes so you can scroll down the data and keep the column headers displayed.
On occassion, you cannot scroll down. The indicator on the scroll bar is moving but the display is not.
It appears that the rows which are frozen have changed. When I unfreeze the panes, the horizontal pane bar has moved from row 1 to row 30 (the new row number changes, it's not always the same row number). That gives the appearance that you can't scroll down.
No one who shares the workbook is admitting to unfreezing the panes, moving the pane from row 1 to row 30, and then re-freezing the panes. I doubt any of the users would even know how to do this.
This happens on different excel files and on different shared servers with completely different users. It's not just unique to one workbook.
Any other ideas to what is causing this situation on a shared workbook?
Row 1 (the column headers) is frozen with Windows/Freeze Panes so you can scroll down the data and keep the column headers displayed.
On occassion, you cannot scroll down. The indicator on the scroll bar is moving but the display is not.
It appears that the rows which are frozen have changed. When I unfreeze the panes, the horizontal pane bar has moved from row 1 to row 30 (the new row number changes, it's not always the same row number). That gives the appearance that you can't scroll down.
No one who shares the workbook is admitting to unfreezing the panes, moving the pane from row 1 to row 30, and then re-freezing the panes. I doubt any of the users would even know how to do this.
This happens on different excel files and on different shared servers with completely different users. It's not just unique to one workbook.
Any other ideas to what is causing this situation on a shared workbook?