Why does almost all ofthe text disappear when "Wrap text" is selec

[Guest]

This happens on MS excel 2003. It was fine until the today when a file was
opened almost all of the text was missing from the file. All the rest of the
cell formatting is intact (background colour, size, etc.). I installed Excel
97 in a separate folder just as an experiment, and the same thing happens.
When you disable text wrap, it all comes up ok. The text wrap needs to be
enabled. The OS is Win2k SP4, and no recent software installations have taken
place, besides the excel 97.

 

[Guest]

Maybe check out your cell format options. Text alignment could be set to
top, which may push text out of view

 

[Guest]

I have the same problem. If I turn on wrap text, all of the text or numbers
in a cell disappear, yet they are visible in the fx line. I've tried all of
the cell formatting options concerning row height, positioning, etc. to no
avail. I tried detect and repair - still no change. The only way to view
the cell contents is to turn off text wrap. If I do print preview, the cell
contents are displayed - even with text wrap on.

 

[clipscomb]

We had this problem with one instance of Excel 2003 in our office. We
were able to fix it by running the following command from the RUN line
(START --> RUN):

Excel /RegServer

If you get an error saying Excel cannot be found, use the full path to
Excel.exe

*I have the same problem. If I turn on wrap text, all of the text or
numbers
in a cell disappear, yet they are visible in the fx line. I've tried
all of
the cell formatting options concerning row height, positioning, etc.
to no
avail. I tried detect and repair - still no change. The only way to
view
the cell contents is to turn off text wrap. If I do print preview,
the cell
contents are displayed - even with text wrap on.

:
[vbcol=seagreen]

Maybe check out your cell format options. Text alignment could be set to
top, which may push text out of view

:
*

 

[monabaker]

I have tried Excel /RegServer and it does not help anything. I have tried running a repair and it does not help. I did a complete uninstall, and then a full reinstall, and it does not help.

WTF is going on?!!?

Everytime I select a cell for WRAP TEXT, everything inside the cell vanishes and can only be seen up on the display bar, and no longer in the cell.


HELP!!!!!!!!!!!!!!!!!!!!!!

 

[Eric Stutes]

Help Me Too!!!

I am having the same problem. Has anyone figured out how to fix it?

 

[Mister_Gloom]

I was able to fix this issue by updating my video driver. It can't hurt to try.

 

[flatiron666]

I've had this same issue, win XP, SP2 on a dell Latitude D600 laptop. Has a Radeon 9000 video card in it. I tried the "excel /regserver" but that didn't help. I redownloaded my video driver off the Dell website (same version I already had); extraced the files and replaced what was already on the harddrive. I uninstalled the video driver, restarted, windows automatically reloaded the video driver and Excel started working normally again.

I'm not sure where the problem came from, but uninstalling the video driver and restarting was enough to get it working again.

 

[dlw]

Less drastic fix

I had the same issue with the text being in the cell (according to the Function bar) but not showing up on screen unless I disabled word wrap. The only change I had made was some tweaking of my dual monitor setup so I suspected a video problem.

Rather than uninstalling/reinstalling the driver, I changed the screen resolution and the text reappeared. I changed the resolution back to the previous value and the text was still visible. I wonder if this is a dual monitor glitch?

Hope this helps

 

[cowlinator]

Strange but true, re-installing the video driver does seem to work.

 

[amat_endura]

Does this help?

I came across this thead when trying to fix a similar problem, and on a different search found that the character limit of a single cell is 1024 for some versions. No amount of formatting will change this.

http://exceltips.vitalnews.com/Pages/T1296_Character_Limits_for_Cells.html

Regards,
Paul.

 

[DenisJ]

Thank you all

Thank you all for the leg work.

Updating the video driver would have been, oh about the 1,000th thing I would have thought of doing.

 

[greedyefx]

Change your resolution

I just had this problem and I changed my resolution which made all text appear as it should. The text still appeared when I set my resolution back to it's original setting.

 

[airborn_tech]

Changing Resolution Works

Thank you for posting the fix. Changing the video resolution fixes the problem (and then you can change it back). This occurred on a Dell Latitude D810 running Windows XP SP2, Office 2003 Pro SP3, and an ATI Mobility Radeon X600 running 2 displays.


Thanks again!

 

[JayB]

I've experienced this problem 3 times on a Dell Latitude D610 running Windows XP SP2 with Office 2003 Pro SP2.
Each time, I've been able to quickly fix it by toggling the display resolution. Thank you so much for the tip!