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

On 4/4/2010 9:07 AM, wrote:
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.

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.

" wrote:

On 4/4/2010 9:07 AM, wrote:
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.
.

On 4/5/2010 12:03 AM, JLatham wrote:
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.

" wrote:

On 4/4/2010 9:07 AM, wrote:
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.
.

Thanks.