Excel adds "Copy of" to file name

  • Thread starter Thread starter KudaMuda
  • Start date Start date
K

KudaMuda

I frequently copy protect my Excel files to prevent overwriting
working file I am using as a template.

For example I may open the read only "Filename001.xls" make a fe
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 a
on a read only file it adds the text "Copy of" to the beginning of th
file name (i.e. from "Filename001.xls" to "Copy of Filename001.xls")

How can I prevent Excel from automatically adding the extra text? I
caused me to loose and redo a lot of work before I realized what wa
going on. It is also time consuming to have to delete the superfluou
text 20-30 times a day.

Any help?
:confused
 
KudaMuda said:
I frequently copy protect my Excel files to prevent overwriting
working file I am using as a template.

For example I may open the read only "Filename001.xls" make a fe
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 a
on a read only file it adds the text "Copy of" to the beginning of th
file name (i.e. from "Filename001.xls" to "Copy of Filename001.xls")

How can I prevent Excel from automatically adding the extra text? I
caused me to loose and redo a lot of work before I realized what wa
going on. It is also time consuming to have to delete the superfluou
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 i
without the read onl
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top