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, (E-Mail Removed) 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.

"(E-Mail Removed)" wrote:

> On 4/4/2010 9:07 AM, (E-Mail Removed) 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.
>
> "(E-Mail Removed)" wrote:
>
>> On 4/4/2010 9:07 AM, (E-Mail Removed) 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.