Sheet will not display

[Steve]

I am running Excel 2000 on Windows 95 Plus computer. I
created a worksheet on an NT machine in excel 2000. I
then installed excel 2000 on the windows 95 machine.
Excel opens fine. When it opens, there is a blank
worksheet. Everything looks normal. When I open the
worksheet I created on the NT machine, the sheet does not
show up, it looks as if I have excel open with all
worksheets closed. However, in the formula bar it
displays a word that is in the worksheet. So, its like
the worksheet is there but I can't see it.

I hope this explanation makes sense.

Thanks for any help
steve

 

[Simon Murphy]

Steve
Try typing Alt F11 to open the vbide, if it opens type
application.screenupdating=true and hit enter
I've seen this problem in xp and this fixes it
Never seen it in 2000 though.
Another possibility is Windows>>unhide, although that is
not consistent with the formula bar showing valid data.

cheers
Simon

 

[Jan Karel Pieterse]

Hi Troubled,

I am having the same problem. I went to VBA IDE and couldn't locate where to type the screenupdating portion. It comes up as a VBA editing window.

In the VBE, hit control-g to open the immediate window. Type it there, followed by an enter
(whilst the cursor is on the line with the screenupdating text)

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com