compatibility mode

[Jeff]

I am a new user of Excel 2007 and have previously used Excel 2002.

I have received an Excel sheet which opens in "Compatibility mode" and
as "Read only". When I try to save it, it will only save as a copy and
defaults to Excel 93-2003 format, so I assume that is how it was
created. When I delete empty rows or columns at the end of the database
and save the file and then reopen it the deleted rowa/columns are still
there in the saved copy.

a) what am I doing wrong?
b) how do I open it in non "compatibility mode" and not as "read only"?
c) hoe do I delete excess rows/columns and make it stick? (I did select
remove rows).

Hope you can help. Thanks.
Jeff

 

[Jeff]

I am a new user of Excel 2007 and have previously used Excel 2002.

I have received an Excel sheet which opens in "Compatibility mode" and
as "Read only". When I try to save it, it will only save as a copy and
defaults to Excel 93-2003 format, so I assume that is how it was
created. When I delete empty rows or columns at the end of the database
and save the file and then reopen it the deleted rowa/columns are still
there in the saved copy.

a) what am I doing wrong?
b) how do I open it in non "compatibility mode" and not as "read only"?
c) hoe do I delete excess rows/columns and make it stick? (I did select
remove rows).

Hope you can help. Thanks.
Jeff

Saved the file in Excel 2007 file and all problems disappeared.

 

[JLatham]

Should have been able to save it as 97-2003 format as long as you saved it as
a new name. When any workbook is opened as Read Only, you can't save any
changes, such as the row/column deletes you made ... unless you save it with
a new name.

 

[Jeff]

Should have been able to save it as 97-2003 format as long as you saved it as
a new name. When any workbook is opened as Read Only, you can't save any
changes, such as the row/column deletes you made ... unless you save it with
a new name.

Thanks.