search

microsoft / advanced-formula-environment

Create, edit, and reuse formulas in Excel
https://aka.ms/get-afe
MIT License
113 stars 11 forks source link

Not recognizing Microsoft 365 Account #11

Open dbill74 opened 2 years ago

dbill74 commented 2 years ago

Using Excel Desktop installation get the following message "This add-in won't run in your version of Office. Please upgrade to either one-time purchase Office 2021 or to a Microsoft 365 account." I already have a Microsoft 365 account. Tried Excel Online (office.com) and I do not get this message. I am not only one getting this, see comment section of https://techcommunity.microsoft.com/t5/excel-blog/announcing-lambdas-to-production-and-advanced-formula/bc-p/3216298#M2608

Am I missing something or is this a bug?

no-identd commented 2 years ago

@dbill74 Please do share some sufficiently censored/redacted for your privacy requirements screenshot of the excel about/version dialog of your installation. It's quite possible you've used an M365 account to sign into an older Microsoft Office installation such as Microsoft Office 2016 VLK. Also, depending on which M365 subscription you have this subscription might not include desktop Microsoft Excel, which you may have purchased and/or obtained separately previously.

aromerom56 commented 2 years ago

I have receiving the same message: "This add-in won't run in your version of office. Please upgrade to either one-time purchase Office 2021 or to a Microsoft 365 account" I have a subscription of Office 365: Captura de pantalla 2022-02-27 214902_LI Captura de pantalla 2022-02-27 215006_LI

jack-williams commented 2 years ago

The reason why this message displays is because we detect the browser running the add-in taskpane is either Internet Explorer or EdgeHTML, which we do not support. The error message is not helpful, and I have a pending fix to improve the message.

Just to confirm that you are seeing this message for the expected reason: if you click the arrow in the top right of the taskpane and go to info, you should see the runtime for the task-pane.

(arrow to click) image

(info) image

Under "runtime", I suspect you might see something different, which would explain why we show this message. This page lists the build versions and task-pane runtimes: https://docs.microsoft.com/en-us/office/dev/add-ins/concepts/browsers-used-by-office-web-add-ins. You'll need "WebView2 (Chromium Based)" to run AFE.

aromerom56 commented 2 years ago

Hi,

Maybe I don’t explain me.

I am not using Excel on browser; I am using the desktop version and I have a subscription to office 365.

In fact, it is working on Excel online but not in the desktop version.

Regards.

Alejandro Romero

From: Jack Williams @.> Sent: miércoles, 2 de marzo de 2022 10:06 a. m. To: microsoft/advanced-formula-environment @.> Cc: aromerom56 @.>; Comment @.> Subject: Re: [microsoft/advanced-formula-environment] Not recognizing Microsoft 365 Account (Issue #11)

The reason why this message displays is because we detect the browser running the add-in taskpane is either Internet Explorer or EdgeHTML, which we do not support. The error message is not helpful, and I have a pending fix to improve the message.

Just to confirm that you are seeing this message for the expected reason: if you click the arrow in the top right of the taskpane and go to info, you should see the runtime for the task-pane.

(arrow to click) https://user-images.githubusercontent.com/4489219/156398889-fda937b9-0648-4bc3-85e9-20657919d3fc.png

(info) https://user-images.githubusercontent.com/4489219/156398593-3ed285b9-4e87-4497-aad4-6fa16aa705d9.png

Under "runtime", I suspect you might see something different, which would explain why we show this message. This page lists the build versions and task-pane runtimes: https://docs.microsoft.com/en-us/office/dev/add-ins/concepts/browsers-used-by-office-web-add-ins. You'll need "WebView2 (Chromium Based)" to run AFE.

— Reply to this email directly, view it on GitHub https://github.com/microsoft/advanced-formula-environment/issues/11#issuecomment-1057096656 , or unsubscribe https://github.com/notifications/unsubscribe-auth/ALPWUEII4RMB2LARKXVTAUTU56GVTANCNFSM5PM76ICA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub . You are receiving this because you commented. https://github.com/notifications/beacon/ALPWUELVV2BDZQTQ7GNNKA3U56GVTA5CNFSM5PM76ICKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOH4BAHUA.gif Message ID: @. @.> >

mitchcapper commented 2 years ago

@aromerom56 they understand they are asking about desktop Excel. To use this addon and others microsoft runs them in an embedded browser instance inside Excel. They believe your excel is using an old render engine and not the latest Edge builds causing the error.