Excel XP won't scroll view
Posted on 2002-04-24
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."