mivers wrote: ↑Fri Sep 30, 2022 5:46 pm
How did you get the add-in to work with Office 365 versus Office 2016? I use the Perspectives add-in. Not sure how to get this to work with 365.
Thanks for any assistance.
Note the dates on the previous messages in this thread; 2020.
Now, Microsoft being Microsoft and loving to rename things just to hack customers off, what was THEN called Office 365 (and the thing that we were talking about in that thread) is now part of "Microsoft 365". That is, a subscription service where you install the applications on your Windows device and run them locally.
(Actually the name had changed a couple of months before that but Microsoft don't pay me enough to keep up to date with the latest brain flatulence of their marketing 'droids.")
Confession time; I do still often refer to this as "Office 365" even to this day, since I generally
want to refer to the Office applications and
not to extended sets of applications that I may not give a flying fig about. With the "broad enough to be meaningless" name "Microsoft 365" there is now no neat way of doing that. (Microsoft: "Uuuuuh, duh, we didn't fink of that!") What makes it worse is when they recycle a name that used to mean one thing to refer to something else, as has happened here.
What is NOW Office 365 is what was THEN known as Office for the Web (or "Office on the Web", or any of half a dozen similar names). This is not the thing that we were talking about, but I presume it's what
you're talking about. In which case the answer is... you can't.
You will have already noticed that there is nothing in File => Options that lets you add add-ins. (In fact there is damn near nothing in Options compared to the real Excel.)
However the killer can be found in
this article in Microsoft's support pages:
File formats that are supported in Excel for the web
- Excel workbook files (.xlsx)
- Excel 97-2003 workbook files (.xls).
- Note: When you open this file format, Excel for the web will convert it to a newer .xlsx file. You can always download the original by going to File > Info > Previous versions.
- CSV (Comma delimited) file (.csv)
- Note: When you open this file format, Excel for the web will convert it to a newer .xlsx file. You can always download the original by going to File > Info > Previous versions.
- Excel binary workbook file (.xlsb)
- OpenDocument Spreadsheet file (.ods)
- Excel macro-enabled workbook (.xlsm)
- A workbook in this format can be opened but macros do not run in a browser window.
(My emphasis.)
Since Perspectives is essentially a macro-based workbook, no macros means no Perspectives.