Office97 -> XP. Excel opens blank spreadsheets (unprivileged user)

[news.microsoft.com]

I have recently upgraded Office 97 to Office XP on our Win2000 machine
(SP3). When we open some of our old spreadsheets they come up as a blank
spreadsheet - ie there are not even any cells visible. This problem goes
away if we log in as Administrator. We are still able to open these files
as a nonprivileged user on Office 2000 on another system in our office.

Any suggestions?

 

[Dave Peterson]

Maybe it's just off the viewable screen:
Window|Arrange|tiled

Or maybe it's not really staying open.
Hit alt-f11 to get to the VBE after you try opening the problem file.
hit ctrl-R to see the project explorer.

Do you see your workbook name in that windows explorer like list?
something like: VBAProject (yourworkbookname.xls)

If you don't see that, then your workbook isn't opening (or staying open).

Start Excel in safe mode
Windows Start Button|Run
Excel /s

open your file

And see if you notice a difference. If you do, maybe you have a macro running
that's checking something and closing because it didn't like what it found out.