Help! I can't see the text in my non-empty cells.

[NG]

Hi,

I am using Office 2007 and I have noticed something strange. My workbook is
quite simple and not very large (300KB). In the most busy spreadsheet, I am
using vlookup about 700 times and there are about 1500 cells with drop down
boxes - it is a data collection tool where some of the answers are pre-filled.

Sometimes non-empty cells, even those with text only in them, will appear to
be empty and you need to click in them or move around the spreadsheet before
their content becomes visible again. Any ideas on what is doing this?
Needless to say, the user will not be guided properly if they can not see the
instructions.

Thank you very very much for giving me a hand!

 

[Shane Devenshire]

Hi,

I have noticed screen refresh problems in Office 2007. I think these are
related to the higher quality graphics, but I'm not sure. I usually press
PgDn, PgUp to get the screen to update in these cases. Maybe someone else
will add some additional insight

 

[Dave Peterson]

Do you use multiple monitors?

Hi,

I am using Office 2007 and I have noticed something strange. My workbook is
quite simple and not very large (300KB). In the most busy spreadsheet, I am
using vlookup about 700 times and there are about 1500 cells with drop down
boxes - it is a data collection tool where some of the answers are pre-filled.

Sometimes non-empty cells, even those with text only in them, will appear to
be empty and you need to click in them or move around the spreadsheet before
their content becomes visible again. Any ideas on what is doing this?
Needless to say, the user will not be guided properly if they can not see the
instructions.

Thank you very very much for giving me a hand!

 

[NG]

Thanks a lot for your quick answer Shane, but I can not test this yet as I
have run into a bigger problem: My file is now officially unable to open. I
get an error saying "Microsoft Office Excel has stopped working". My other
Excel files are still ok, but not this one. I think I am cursed...

Nina

 

[NG]

Hi Dave,

Well... not right now but I did hook up to a projector this morning... Are
we on to something?

Nina

 

[Dave Peterson]

If you disconnect the projector, do things come back to normal?

I have no idea if this will work for you, but...



There have been some people who complained that the text would appear in the
formula bar, but not in the cell in the worksheet.

http://groups.google.co.uk/group/mi...isplay+group:*excel*&rnum=16#7109488256478b2d

or

http://snipurl.com/1crbf

Mike Brambley posts a link to a suggestion that worked for him.

 

[Dave Peterson]

ps. Please post back with your results in either case.

 

[NG]

Dave, I definitely will. But my problem now is that I can no longer open that
file at all - it shows "Excel has stopped working" and closes. Any pointers
for that?

 

[Dave Peterson]

That doesn't sound good.

Do you have a backup version you could try?

I'm not sure if OpenOffice supports xl2007 file formats...

You may want to look at that. Lots of people have had good luck with it.
http://www.openoffice.org, a 60-104 meg download or a CD

If the file is really important, there are commercial recovery services. I've
never used it, but you might want to check into:
http://www.officerecovery.com

Dave, I definitely will. But my problem now is that I can no longer open that
file at all - it shows "Excel has stopped working" and closes. Any pointers
for that?