MarkSheedy
New Member
- Joined
- May 16, 2011
- Messages
- 1
Using Excel 2003 - SP3
(1) I have a sheet that has frozen panes created as follows
First I split the window at row 400.
- We now have a top and bottom pane
Then I scroll the top pane down to row 200
I then freeze the window
- So now, rows 200-215 and 400 are visable
Now, I move the selection into the bottom pane, and scroll down to row 800.
Now, I would expect that when I scroll back up that it would scroll back to row 400, and this is what normally happens.
However, if I close and reopen the sheet (2), the scroll pane gets stuck at row 800.
The selected cell still changes (as I can see in the top left box), but the pane does not scroll.
Any help would be much appreciated,
M.
(1) When I say "I", i'm am actually relating this story from another excel user. I am doing this as the user is not a techical user of excel.
(2) This does not happen all the time. It seems to only happen if the sheet is open for extended persiods of time - say 3-4 days at a time.
(1) I have a sheet that has frozen panes created as follows
First I split the window at row 400.
- We now have a top and bottom pane
Then I scroll the top pane down to row 200
I then freeze the window
- So now, rows 200-215 and 400 are visable
Now, I move the selection into the bottom pane, and scroll down to row 800.
Now, I would expect that when I scroll back up that it would scroll back to row 400, and this is what normally happens.
However, if I close and reopen the sheet (2), the scroll pane gets stuck at row 800.
The selected cell still changes (as I can see in the top left box), but the pane does not scroll.
Any help would be much appreciated,
M.
(1) When I say "I", i'm am actually relating this story from another excel user. I am doing this as the user is not a techical user of excel.
(2) This does not happen all the time. It seems to only happen if the sheet is open for extended persiods of time - say 3-4 days at a time.