If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
compatibility mode
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 |
#2
|
|||
|
|||
compatibility mode
|
#4
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|