+ Reply to Thread
Results 1 to 6 of 6

Office 2010 Save inserts "Copy of" in filename

  1. 10-09-2014, 12:57 PM #1
    amthyst826
    amthyst826 is offline
    Registered User
    Join Date
    10-24-2005
    Location
    Lake Forest, CA
    MS-Off Ver
    2007
    Posts
    56

    Unhappy Office 2010 Save inserts "Copy of" in filename

    How do I turn this off?

    I haven't figured out what triggers it, but sometimes when I hit F12 Excel inserts "Copy of " into the filename.

    Doesn't happen all the time, just enough to mess me up if I don't catch it.

    MS Office 2010 installed recently, previously with Office 2007 this did not happen

    Appreciate any guidance you could offer
    Reply With QuoteRegister To Reply
  2. 10-09-2014, 01:07 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,422

    Re: Office 2010 Save inserts "Copy of" in filename

    Maybe this will help: http://excel.tips.net/T003064_Gettin...f_Copy_of.html


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 10-09-2014, 01:44 PM #3
    amthyst826
    amthyst826 is offline
    Registered User
    Join Date
    10-24-2005
    Location
    Lake Forest, CA
    MS-Off Ver
    2007
    Posts
    56

    Re: Office 2010 Save inserts "Copy of" in filename

    I'm not familiar with this. I don't know how to apply the script provided on the link that was suggested.
    Reply With QuoteRegister To Reply
  4. 10-09-2014, 03:10 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,422

    Re: Office 2010 Save inserts "Copy of" in filename

    How to install your new code
    1. Copy the Excel VBA code
    2. Select the workbook in which you want to store the Excel VBA code
    3. Press Alt+F11 to open the Visual Basic Editor
    4. Double click on the ThisWorkbook module in the left hand pane to select it
    5. Edit > Paste the macro into the module that appeared
    6. Close the VBEditor
    7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

    The code should execute automatically when you try to use Save As.
    Reply With QuoteRegister To Reply
  5. 10-10-2014, 02:26 PM #5
    amthyst826
    amthyst826 is offline
    Registered User
    Join Date
    10-24-2005
    Location
    Lake Forest, CA
    MS-Off Ver
    2007
    Posts
    56

    Re: Office 2010 Save inserts "Copy of" in filename

    Thanks!!!
    Reply With QuoteRegister To Reply
  6. 10-10-2014, 03:28 PM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,422

    Re: Office 2010 Save inserts "Copy of" in filename

    You're welcome.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] code from office dev center for excel 2010 regarding "ReadOnly Property MultiUserEditing"
    By rt3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2013, 03:50 AM
  2. [SOLVED] "Save As" in current directory, filename from cell value
    By AlexCoyne in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2012, 08:33 PM
  3. VBA - Save AS, filename from cell as date in format "YYYY-MM-DD"
    By lukestkd in forum Excel General
    Replies: 0
    Last Post: 08-09-2012, 04:31 PM
  4. Opening excel in office 2010 and not office "starter"
    By AlisonK in forum Excel General
    Replies: 3
    Last Post: 03-02-2012, 10:01 AM
  5. Excel 2003 - Save As function inserts "Copy of"
    By Tko2000 in forum Excel General
    Replies: 0
    Last Post: 08-04-2006, 10:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1