Solved

can't save excel 2010  xlsm workbook as xltm template

Posted on 2013-05-24
4
752 Views
Last Modified: 2013-05-29
I have an Excel 2010 template (OSI.xltm) with macros that I used to create a new workbook (NewFile.xlsm). I then went to "save as" type xltm but the drop down types only has xlsm. What am I doing wrong?
0
Comment
Question by:BobArnett
  • 3
4 Comments
 

Author Comment

by:BobArnett
Comment Utility
Addition info:
The workbook is not protected. The worksheets are although I tried "save as" with the worksheets unprotected.
0
 
LVL 9

Expert Comment

by:jsdray
Comment Utility
try saving it as an xlsm first then reopen and save as xltm
0
 

Accepted Solution

by:
BobArnett earned 0 total points
Comment Utility
Figured it out. There was some code (I'm not sure where it came from) that prevented saving the file as anything other than xlsm.
0
 

Author Closing Comment

by:BobArnett
Comment Utility
Sorry to waste your time.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now