compatibility mode

J

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
 
J

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.
 
J

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.
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top