[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 855
  • Last Modified:

can't save excel 2010 xlsm workbook as xltm template

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
BobArnett
Asked:
BobArnett
  • 3
1 Solution
 
BobArnettAuthor Commented:
Addition info:
The workbook is not protected. The worksheets are although I tried "save as" with the worksheets unprotected.
0
 
jsdrayCommented:
try saving it as an xlsm first then reopen and save as xltm
0
 
BobArnettAuthor Commented:
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
 
BobArnettAuthor Commented:
Sorry to waste your time.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now