Missing row numbers and column letters

[nemotski]

One Excel workbook opens with neither row numbers nor column letters
displayed. The cells are there but simply grey. The problem has
occurred only recently and the file has been in use for several years.
All sheets are affected. All columns, rows and data are present. No
other workbooks are affected.

Restarting the computer has no effect.

Excel 10.1.6 running under OS 10.2.8.

If I transfer the file to an iBook running OS 10.3.6 it opens correctly
and there is no problem. Equally, it opens correctly on a PC.

I think the problem began after working on the file on the iBook
(10.3.6) and transferring it back to the desktop machine (10.2.8).
Does anybody have some ideas please?

Thanks

 

[JE McGimpsey]

One Excel workbook opens with neither row numbers nor column letters
displayed. The cells are there but simply grey. The problem has
occurred only recently and the file has been in use for several years.
All sheets are affected. All columns, rows and data are present. No
other workbooks are affected.

Restarting the computer has no effect.

Excel 10.1.6 running under OS 10.2.8.

If I transfer the file to an iBook running OS 10.3.6 it opens correctly
and there is no problem. Equally, it opens correctly on a PC.

I think the problem began after working on the file on the iBook
(10.3.6) and transferring it back to the desktop machine (10.2.8).
Does anybody have some ideas please?

Choose Excel/Preferences/View and check the "Row and column numbers"
checkbox.

 

[nemotski]

Thanks for the reply but the box is already checked. If I uncheck this
box the grey cells in which the letters and numbers should appear
vanish entirely. Checking the box again restores them but without
letters or numbers.

 

[JE McGimpsey]

Thanks for the reply but the box is already checked. If I uncheck this
box the grey cells in which the letters and numbers should appear
vanish entirely. Checking the box again restores them but without
letters or numbers.

If it's only the one workbook, I'd guess that it's corrupted. If you
were using XL04, the first thing I'd try is saving it as XML. In XLv.X,
I'd try saving it as SYLK. You'll lose objects and code (save code, if
you have any, separately to text files)

Unfortunately, if that doesn't work, it usually means copy/pasting the
workbook contents to a new workbook.

 

[nemotski]

If it's only the one workbook, I'd guess that it's corrupted. If you
were using XL04, the first thing I'd try is saving it as XML. In XLv.X,
I'd try saving it as SYLK. You'll lose objects and code (save code, if
you have any, separately to text files)

Unfortunately, if that doesn't work, it usually means copy/pasting the
workbook contents to a new workbook.

I began to wonder whether it was corrupted but it seemed so subtle for
corruption. Anyway I have copied and pasted across to a new workbook
as you suggest so I can carry on my work. Thanks for your help.