Formatting problem Excel

[George Andrews]

Using Office 2000

I am regularly sent files in Excel format which have been extported from
database applications.

Everything seems normal except that when I right-click a cell and select
Format - Nothing happens. No Format menu opens. The same happens (i.e.
nothing) when I select Format_Cells from the format menu.

However if I go to another workbook and format a cell then it works as
normal.

Also if I copy a format using the format painter in a different workbook,
and then paste the format to a cell in the Problem workbook then the format
changes.

Can anybody tell me how to sort this Format problem out?

Thanks in advance.

George

 

[Peter T]

Hi George,

The scenario you describe fits the combination of non
locked cells on a protected sheet (Tools > Protection).

Regards,
Peter

 

[George Andrews]

Peter,

That has not worked. The sheet is not protected and I have now Unlocked all
cells on the sheet. I have discovered that if I select a column and then
Right-click Format, then the Format window appears and allows me to make
changes however if I select a range or individual cell and Right-click
Format, then it still does not work (appear).

do you have any other ideas?

George

 

[Peter T]

This, maybe:

http://support.microsoft.com/?kbid=818082
Title: You cannot format data imported from Access 2002 to
Excel 2000 or to Excel 97

Regards,
Peter

 

[George Andrews]

Yes, that is it.

Thanks.

George

This, maybe:

http://support.microsoft.com/?kbid=818082
Title: You cannot format data imported from Access 2002 to
Excel 2000 or to Excel 97

Regards,
Peter

 

[Peter T]

Good, in one sense. But I presume you will need to
continue with the proposed workaround.

This is a bit off the wall, but for my curiosity could you
run this on a backup of one of your problematic sheets:

Sub ClearAllBorders()
Cells.Borders.LineStyle = xlNone
End Sub

Regards,
Peter