[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Excel XP won't scroll view

Posted on 2002-04-24
8
Medium Priority
?
340 Views
Last Modified: 2011-09-20
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."
0
Comment
Question by:esc_toe_account
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 44

Expert Comment

by:bruintje
ID: 6966616
Hi esc_toe_account,

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
0
 
LVL 44

Expert Comment

by:bruintje
ID: 6966633
OK check your

-options
-tab view
-left there are the scrollbars and tabs guess these are unchecked in your workbook

:O)Bruintje
0
 

Author Comment

by:esc_toe_account
ID: 6966951
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.)
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 44

Expert Comment

by:bruintje
ID: 6966969
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...
0
 

Author Comment

by:esc_toe_account
ID: 6967028
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!
0
 
LVL 44

Accepted Solution

by:
bruintje earned 500 total points
ID: 6967063
the only thing i can think of now is that in a way the freeze panes (windows
 freeze panes) played up, and has the sheet frozen just in the left down corner in a strange way and so you can see only this part and the rest is behind the frozen part of the sheet

i would be inclined to report this directly to MS, maybe send that weird workbook to them and see if they explain what is happening

:O)Bruintje
0
 

Author Comment

by:esc_toe_account
ID: 6967077
Bingo! It was a strange freeze panes scenario. Removing and adding back in freeze panes solved the problem.
0
 
LVL 44

Expert Comment

by:bruintje
ID: 6967089
guess it is really my lucky day earning points on hunches

glad it worked out and thanks for the grade
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question