Could this be an easter egg bug?

R

RLS111

Any old or new Excel 2003 workbook I open has this same problem:

Row 7 intermittently fails to display the value of various cells. At any
given point while working in a sheet, one or several cells in row 7 will not
display the value. Selecting the cell will show the value in the formula
bar, and opening the cell for edit usually makes it visible again. So for
example, I open a new workbook. WITHOUT CHANGING ANY FORMATTING, I begin to
type an "X" in each of the first 10 rows and 10 columns (100 X's). As I
type, one or several cells in row 7 will appear to be empty. Selecting the
cell shows an X in the formula bar, but not the cell. If I double-click the
cell to edit it, the X will usually display in the cell again, whether I
actually edited it or not. As I continue to work in other cells, the same
cell or another one will go blank again.

Again,
This affects all (including new) workbooks
It only happens in row 7
It happens to different cells in row 7 at different times
No formatting changes are made (e.g. white text)
The columns are more than wide enough to display the values

I'd appreciate any help getting this fixed. Thanks.
 
K

Ken Wright

Is there any conditional formatting on any of the cells that exhibit this
behaviour? I know it's a new book, but just check anyway in case you are
opening a template or something that someone has mucked about with.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
R

RLS111

Thanks for the reply, Ken. I checked row 7 and several individual cells, as
well as cells in other rows. All say there is no conditional formatting set.
 

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