Discussion Locked

Excel question

0 helpful
9 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Have standard w2k and office 2000 build on various PC's. Svce packs appear up to date. On one PC, an xls spreadsheet does not open. Get blank "grey" page. On another PC with same specs, it opens fine.
Looks like all the settings appear the same, eg. Tools>Macro>Security set to High, but does not work even if wet to Low (on problem PC).
Under Windows>Hide ... it is definitely not hidden.
Other small settings appear the same also. The xls was originally emailed...a standard proceedure for these users. The problem PC could open the emails/xls's a few days ago...
Absolutely "baffled"!
Any help appreciated...thx in advance.

9 replies

by smlandau

1. Have the sender resend the document and then try to open it. If possible turn off any macros to keep it in a plain vanilla state.

2. Have someone else log onto this PC and try to open the document. You might have a corrupt windows profile.

by kbarry

Whenever Word or Excel shows signs of unordinary startup I delete the template.
Open Windows Explorer, goto Tools|Folder Options and make sure you show hidden files.
Search for book.xlt (normal.dot for word) and delete all found.
Open Excel.
Youwill now have a default Excel workbook.

by dklippert

Go to Tools>Options. On the General tab remove the check mark from "Ignore other applications"

by rpbradsr

Here's something simple, check the formatting for
the cells. Sometimes the Pattern can hide the cells contents.
Select the entire sheet and then make sure
Format-Cells-Patterns is set to No Color.

This discussion is closed to new replies.