View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Bryan Hessey
 
Posts: n/a
Default excel wrap text no show


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

--

Aline Wrote:
Hi Bryan,

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

Kind regards,
Aline



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=534903