Formatting problem Excel
 

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

Formatting problem Excel
 

Hi George,

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

Regards,
Peter

-----Original Message-----
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

Formatting problem Excel
 

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" wrote in message
...
Hi George,

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

Regards,
Peter

-----Original Message-----
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

Formatting problem Excel
 

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


-----Original Message-----
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" wrote in
message
...
Hi George,

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

Regards,
Peter

-----Original Message-----
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



.

Formatting problem Excel
 

Yes, that is it.

Thanks.

George

"Peter T" wrote in message
...
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


-----Original Message-----
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" wrote in
message
...
Hi George,

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

Regards,
Peter

-----Original Message-----
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



.

Formatting problem Excel
 

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


-----Original Message-----
Yes, that is it.

Thanks.

George

"Peter T" wrote in
message
...
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


-----Original Message-----
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" wrote in
message
...
Hi George,

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

Regards,
Peter

-----Original Message-----
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



.



.