This action won't work on multiple selections
sometimes when i tried to add sheet in windows or Mac manually or through code, i am receiving the following error "This action won't work on multiple selections".. I checked if multiple sheets got selected, but no. Please help how to resolve and what is the cause for this.MAC- Excel Add-in (.xlam) default location to load
Is there any default location to load .xlam add-in by default on excel opening. the way we have XLSTART folder in windows, do we have any way in mac. currently in mac- we are browsing for add-in from any location(Tools - Excel Add-ins... -> browse).Mac - Data from web using REST API URL
In Mac we have option called, “From HTML” in “DATA” Tab of Excel-2016. We can get data which doesn’t need username and password which are already linked with Excel. Further, in Data tab we have “Get External Data” – “Run Web Query”, which stores the URL in text file which have extension “.iqy” format. Which also gets data which doesn’t need credentials. Is there any way to pass the credentials along with "Data- From HTML", like i wanted to add "Authorization", ContentType" as headers.