ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Saves worksheet as copy (https://www.excelbanter.com/excel-discussion-misc-queries/210889-saves-worksheet-copy.html)

Bead

Saves worksheet as copy
 
After upgrading from Office 05 to 07, our worksheets can only be saved as
copies. We end up with multiple copies since everytime we make a change
Excel will not save the changes, only wants to create a copy. I am assuming
it has something to do with compatability.

Abbey

Saves worksheet as copy
 


"Bead" wrote:

After upgrading from Office 05 to 07, our worksheets can only be saved as
copies. We end up with multiple copies since everytime we make a change
Excel will not save the changes, only wants to create a copy. I am assuming
it has something to do with compatability.



There's indeed a compatability challenge in switching to 07 from an older
version. But to limit this pain, click on the windows ICON (Office Button) on
your menu bar and save the file as 97-2003 version, and ensure you keep the
exact name of the file (delete any "copy of" if any is added)


All times are GMT +1. The time now is 07:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com