Scroll not behaving as expected

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.
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Threads
1,224,586
Messages
6,179,729
Members
452,939
Latest member
WCrawford

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top