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.

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

Thanks for responding Dave. Your first suggestion of edit|goto made no
difference, in fact the whole workbook is password protected so I could go to
Format|Row but none of the options there are available.

Going to the Print Preview however did display the data in the preview. At
the very least the user can print the data. I'm still very puzzled about the
workbooks' behavior on this particular PC.

"Dave Peterson" wrote:

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

Maybe it's a frozen window?
Window|Unfreeze panes

Maybe it's the scroll area that's set.
select one of the sheets
Hit alt-f11 to get to the vbe
hit ctrl-g to see the immediate window
type this and hit enter:
ActiveSheet.ScrollArea = ""

I'm running out of guesses....


Rob wrote:

Thanks for responding Dave. Your first suggestion of edit|goto made no
difference, in fact the whole workbook is password protected so I could go to
Format|Row but none of the options there are available.

Going to the Print Preview however did display the data in the preview. At
the very least the user can print the data. I'm still very puzzled about the
workbooks' behavior on this particular PC.

"Dave Peterson" wrote:

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


--

Dave Peterson