XLAM Not Available in Excel 2016

[impulsepaul]

When I try to save a workbook, I choose save as and get these options.

See screenshot of the SAVE AS File Types I have available in Excel 2016.

https://www.dropbox.com/s/5fczqw85bw1vgtv/xlam missing.png?dl=0

I'm expecting to see XLAM option to be able to create an add in, but not is available.

Any thoughts why?

Thank you,

--Paul

 

[Michael M]

Don't have version 2016 but on other versions it's down near the bottom of the list simply called "Excel Add In"

 

[impulsepaul]

It's not there. That's why I posted a link to a screenshot.

The weird thing, is I open Excel 2016 on another computer and XLAM is there. But on my computer, it is not. Could it be some type of permissions thing?

 

[Michael M]

It's not a read only file is it ???
Sorry...I can't read the Image you posted !

 

[Michael M]

Have you also checked the Options
File>>Options>>Addins>>Excel Addins at the bottom of the page ??

 

[Amanda Wilso]

1. Click the [FONT=wf_segoe-ui_semibold]File tab, click [FONT=wf_segoe-ui_semibold]Options[/FONT], and then click the [FONT=wf_segoe-ui_semibold]Add-Ins[/FONT] category.[/FONT]
   
2. In the [FONT=wf_segoe-ui_semibold]Manage box, click [FONT=wf_segoe-ui_semibold]Excel Add-ins[/FONT], and then click [FONT=wf_segoe-ui_semibold]Go[/FONT].[/FONT]
   The [FONT=wf_segoe-ui_semibold]Add-Ins dialog box appears.[/FONT]
   
3. In the [FONT=wf_segoe-ui_semibold]Add-Ins available box, select the check box next to the add-in XLAM, and then click [FONT=wf_segoe-ui_semibold]OK[/FONT].[/FONT]

 

[impulsepaul]

I did exactly the steps above and I only have 5 add ins available:
Analysis ToolPak
Analysis ToolPak - VBA
Euro Currency Tools
IIF Trasaction Creator Pro
Solver Add-In

I don't have an option for XLAM.

Any idea why that would be missing?

 

[AliGW]

I have 2016 on an Office 365 subscription and the option to save as .xlam is in the save as file type list. It's not (and as far as I know doesn't need to be) in the add-ins list.

 

[starl]

You're missing a few file types.. is this a company installed version of Excel? Could your IT dept. have limited your file types?

Have you tried saving programatically. try it on a copy, but the fileformat:=55