XLAM Not Available in Excel 2016

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Don't have version 2016 but on other versions it's down near the bottom of the list simply called "Excel Add In"
 
Upvote 0
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?
 
Upvote 0
It's not a read only file is it ???
Sorry...I can't read the Image you posted !
 
Upvote 0
Have you also checked the Options
File>>Options>>Addins>>Excel Addins at the bottom of the page ??
 
Upvote 0
  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]
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,188
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top