excel wrap text no show

[Aline]

Hello,

Cells in Excel with wrap-text format checked do not appear as text
anymore, just a blank cell. Any new data entered with the wrap-text
format checked also show-up as blank. The cell is large enough and text
is in black. When deselecting the wrap text option, text appears again.
All my documents have this problem now and never had it in the past.
Does anyone have a solution?

Kind regards,
Aline

 

[Bryan Hessey]

If you wrap a cell and select that cell, in the formula bar do you see a
number of blank lines following the display?

Do you see the required text in the formula bar?

--

 

[Aline]

Hi Bryan,

No blank lines, and yes, the text is visible in the formula bar.

Kind regards,
Aline

 

[Bryan Hessey]

Interesting, can you copy the sheet to a new book, remove all except a
few such cells and post that either as a .zip file or email to me at
myfullnameas (e-mail address removed)

--

 

[Aline]

Hi Bryan,

I have just sent you an example file by e-mail, hopefully you can find
something.

Kind regards,
Aline

 

[Bryan Hessey]

Hi, email response included:

The file looks ok and I cannot get it to fault.

The only thing that looks out of place is that the first row is 'wrap
text' but a very small amount of data, so no wrap is involved.

With row 1 = wrap, and the other rows not wrapped, if you now reduce
the column size to 1 character wide you will not see any difference in
the display, the cell will NOT wrap on column width adjustment, this
appears normal. When you then rightmouse-Format the cell will
height-adjust to allow for the depth required (but Excel is not that
great at counting height and may make the row wider than required),
reason unknown and it's no big deal.

suggested to remove the Excel11.xlb file from C:\Documents and
Settings\-your name-\Application Data\Microsoft\Excel And let it
re-generate with Excel defaults, also try
Go to the Windows Start menu, and choose Run.
Enter
Excel.exe /regserver

Also - check whether in Excel, Help - Detect and Repair the .xls might
help.

You can also keep a note of which other workbooks you have had open
during the day, to see if some left-over code from there has affected
your setup.

Let me know how you go

Cheers

--