Thread: compatibility mode
View Single Post
  #4  
Old April 5th, 2010, 05:37 AM posted to microsoft.public.excel.newusers
[email protected]
external usenet poster
  
Posts: 35
Default compatibility mode
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.