Excel adds "Copy of" to file name KudaMuda <KudaMuda.2cyb6g_1156266306.4663[ at ]excelforum-nospam.com> 22.08.2006 17:02:56 I frequently copy protect my Excel files to prevent overwriting a working file I am using as a template. For example I may open the read only "Filename001.xls" make a few changes and select save as so I can rename it "Filename002.xls." The problem is with MS Office 2003 SP2 every time I hit save or save as on a read only file it adds the text "Copy of" to the beginning of the file name (i.e. from "Filename001.xls" to "Copy of Filename001.xls") How can I prevent Excel from automatically adding the extra text? It caused me to loose and redo a lot of work before I realized what was going on. It is also time consuming to have to delete the superfluous text 20-30 times a day. Any help? :confused: -- KudaMuda ------------------------------------------------------------------------ KudaMuda's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37887 View this thread: http://www.excelforum.com/showthread.php?threadid=574284

Re: Excel adds "Copy of" to file name Desert Piranha <Desert.Piranha.2cz4kw_1156304410.6335[ at ]excelforum-nospam.com> 23.08.2006 03:36:56 KudaMuda Wrote: > I frequently copy protect my Excel files to prevent overwriting a > working file I am using as a template. [Quoted Text] > > For example I may open the read only "Filename001.xls" make a few > changes and select save as so I can rename it "Filename002.xls." > > The problem is with MS Office 2003 SP2 every time I hit save or save as > on a read only file it adds the text "Copy of" to the beginning of the > file name (i.e. from "Filename001.xls" to "Copy of Filename001.xls") > > How can I prevent Excel from automatically adding the extra text? It > caused me to loose and redo a lot of work before I realized what was > going on. It is also time consuming to have to delete the superfluous > text 20-30 times a day. > > Any help? > :confused:Hi KudaMuda, I would think that the "Read Only" means you cannot change that file, so it can only make a copy. To rewrite the file, or to "Save As" with out the "Copy of" open it without the read only -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28934 View this thread: http://www.excelforum.com/showthread.php?threadid=574284

Re: Excel adds "Copy of" to file name "Gail" <ladylayla[ at ]gmail.com> 23.08.2006 19:08:56 Why not save the file you are using as a template in template format then you cant overwrite it and it will automatically rename it for you "KudaMuda" <KudaMuda.2cyb6g_1156266306.4663[ at ]excelforum-nospam.com> wrote in message news:KudaMuda.2cyb6g_1156266306.4663[ at ]excelforum-nospam.com... [Quoted Text] > > I frequently copy protect my Excel files to prevent overwriting a > working file I am using as a template. > > For example I may open the read only "Filename001.xls" make a few > changes and select save as so I can rename it "Filename002.xls." > > The problem is with MS Office 2003 SP2 every time I hit save or save as > on a read only file it adds the text "Copy of" to the beginning of the > file name (i.e. from "Filename001.xls" to "Copy of Filename001.xls") > > How can I prevent Excel from automatically adding the extra text? It > caused me to loose and redo a lot of work before I realized what was > going on. It is also time consuming to have to delete the superfluous > text 20-30 times a day. > > Any help? > :confused: > > > -- > KudaMuda > ------------------------------------------------------------------------ > KudaMuda's Profile: > http://www.excelforum.com/member.php?action=getinfo&userid=37887 > View this thread: http://www.excelforum.com/showthread.php?threadid=574284 >