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


G

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.
 
Ad

Advertisements

G

Guest

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

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.
 
C

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

:
*
 
Joined
Jan 2, 2007
Messages
1
Reaction score
0
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!!!!!!!!!!!!!!!!!!!!!!
 
Ad

Advertisements

Joined
Apr 23, 2007
Messages
1
Reaction score
0
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

Joined
Jun 26, 2007
Messages
1
Reaction score
0
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
 
Ad

Advertisements

Joined
Oct 19, 2007
Messages
1
Reaction score
0
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.
 
Joined
Feb 20, 2008
Messages
1
Reaction score
0
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.
 
Joined
Apr 11, 2008
Messages
1
Reaction score
0
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!
 
Ad

Advertisements

Joined
Dec 9, 2008
Messages
1
Reaction score
0
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top