esc_toe_account
asked on
Excel XP won't scroll view
I can only see either the top few rows (AutoFilter off or set to 'All') or whatever rows I have filtered to view. in this large single-tabbed spreadsheet (with few formulas) running Excel XP (from Office XP Standard) on a Pentium 4 512M Ram Dell GX240
I can operate on cells I cannot see using shortcut keys and similar techniques. The scroll bar works correctly for whatever cell or areas I have selected, but again, I what is on the screen does not change (unless I change AutoFilter).
Have run Office Repair using CD and Add/Remove programs to no effect. Other spreadsheets operate normally, and when I select a large area from this spreadsheet and paste it into another spreadsheet, or a new tab on the 'problem' spreadsheet, all cells are viewable, scrollable .. "normal."
I can operate on cells I cannot see using shortcut keys and similar techniques. The scroll bar works correctly for whatever cell or areas I have selected, but again, I what is on the screen does not change (unless I change AutoFilter).
Have run Office Repair using CD and Add/Remove programs to no effect. Other spreadsheets operate normally, and when I select a large area from this spreadsheet and paste it into another spreadsheet, or a new tab on the 'problem' spreadsheet, all cells are viewable, scrollable .. "normal."
OK check your
-options
-tab view
-left there are the scrollbars and tabs guess these are unchecked in your workbook
:O)Bruintje
-options
-tab view
-left there are the scrollbars and tabs guess these are unchecked in your workbook
:O)Bruintje
ASKER
Yes, I realize, as I have tested already, that it can all be copied. This is a famous workaround in Excel. But it doesn't always fix hidden problems.
Since this is the second time I have seen a problem like this with Excel XP and would like a solution/prevention rather than copying. There is no other indication of corruption, but if something were to turn up later I would rather find it first.
If you mean Tool/Options/View tab, scrollbars is checked, as mentioned in my question it is visible and working. (Tabs is also checked.)
Since this is the second time I have seen a problem like this with Excel XP and would like a solution/prevention rather than copying. There is no other indication of corruption, but if something were to turn up later I would rather find it first.
If you mean Tool/Options/View tab, scrollbars is checked, as mentioned in my question it is visible and working. (Tabs is also checked.)
so what you're seeing is teh sheet as it opens and you can see everything is normal except that the window content isn't changing on scrolling outside what you already see?
that is really weird...
that is really weird...
ASKER
Weird indeed .. everything I can test works fine, except that when I am working on cells or areas "off the page" I can't actually SEE what I am working on.
I have to copy whatever I have worked on into another spreadsheet or tab to see if what I did worked!
I have to copy whatever I have worked on into another spreadsheet or tab to see if what I did worked!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Bingo! It was a strange freeze panes scenario. Removing and adding back in freeze panes solved the problem.
guess it is really my lucky day earning points on hunches
glad it worked out and thanks for the grade
glad it worked out and thanks for the grade
a workaround would be copy all data to a new workbook
just do a CTRL+A and CTRL+C and in a new workbook a paste
since i two things could be the problem,
-a corrupt workbook
-or a setting where i'm looking for :)
:O)Bruintje