+ Reply to Thread
Results 1 to 2 of 2

Excel not asking to save a template, it just overwrites it

  1. #1
    Registered User
    Join Date
    05-17-2010
    Location
    kent, England
    MS-Off Ver
    Excel 2003
    Posts
    11

    Excel not asking to save a template, it just overwrites it

    We use a number of different Excel templates at my organisation, they are all XLTM format.
    The normal behavior is to open one of these templates, make changes to it and hit save. When you hit save, it opens the save as dialog and you enter a file name and it will save it in XLSM format.
    On my computer though, when i open one of these templates and hit save, it just overwrites the template and it doesn't display the Save As dialog.
    This happens when hitting Ctrl + S, clicking the save icon and when exiting the program. When you exit, it does ask you if you want to save but hitting save just overwrites it.

    I've tried reinstalling but it didn't help.

    Any suggestions?
    Thanks

  2. #2
    Valued Forum Contributor kasan's Avatar
    Join Date
    07-22-2009
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2010
    Posts
    680

    Re: Excel not asking to save a template, it just overwrites it

    Hi,
    How do you open your *.xlmt file? Open empty excel and then File - Open? Or double-click on *.xlmt file?
    There is difference because you can open your template with purpuse to correct it OR you can open copy of this template.
    Right-click on your file and try to choose "New" - this should open copy of template and then you will try to save - SaveAs dialog should appear. If you choose "Open" - this wil open current template and when you will save it - it will be rewrited.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Save excel template PDF and merge it with an other PDF basen on cell value
    By Teresa85 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2015, 06:28 AM
  2. Excel Overwrites Namespaces
    By epitom3 in forum Excel General
    Replies: 0
    Last Post: 10-06-2010, 04:20 AM
  3. Replies: 1
    Last Post: 07-16-2009, 09:14 PM
  4. Excel template on sheet1 save to sheet2
    By tsbone in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2007, 08:42 AM
  5. [SOLVED] save from template to excel sheet
    By ELZNHS00 in forum Excel General
    Replies: 0
    Last Post: 08-02-2006, 12:55 PM
  6. How to save a downloaded excel template to use over and over
    By Theironlumly in forum Excel General
    Replies: 1
    Last Post: 07-25-2006, 11:28 PM
  7. How to save a downloaded excel template to use over and over
    By Theironlumly in forum Excel General
    Replies: 1
    Last Post: 07-25-2006, 08:10 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1