Could this be an easter egg bug?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 :-)
------------------------------­------------------------------­----------------
 
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.
 
Back
Top