View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Some worksheets not viewable within a workbook on a particular PC

Maybe the developer did it on purpose.

They could have hidden the rows and columns.

Select a troublesome sheet
edit|goto
In the reference box, type:
1:65536
then
format|row|unhide
then
format|column|unhide

Maybe it'll help--maybe not...

If you do file|print preview can you see the data?

Rob wrote:

I have a user that has received a workbook created outside the company. The
workbook contains 9 worksheets. When the workbook is opened on her PC only 3
of the worksheets are viewable i.e. you can see the data, gridlines, and on
one sheet a graph. Selecting any of the 6 other worksheets displays only a
blank grey screen. Pressing the arrow keys will cause the scroll bars to
move and the cell position is changed in the name box, but nowhere in the
worksheet can you see data or gridlines. Clicking on the sheet or pressing
Enter seems to select the entire sheet and change the color to a dark green,
but still nothing observable appears. This same workbook copied to my PC
displays all the worksheets with no problem. Both machines are running Excel
2003 SP1. Any thoughs on this will be appreciated, since I'm stumped so far.


--

Dave Peterson