User unable to see the Office Store in Excel (we have it enabled).

Question

User unable to see the Office Store in Excel (we have it enabled).

Erik Metzler 1

User has O365, latest update (and a fresh Online Repair). E3 license.

I have a user that when in Excel has no access to the Office Store. They go to Insert->Get Add-ins only has a tab for Admin Managed. I get all 3 with the same licensing. Below is from mine, but if you ignore the 2 tabs I have, it's the same.

I have confirmed users can get to the store. I have other users that can.

I'm a bit at a loss and can't find anything to address this issue that wasn't solve by fresh install, or the above settings in the admin center.

1 answer

Your answer

Answer 1

Viki Ji_MSFT 4,466

Hi @Erik Metzler ,
Welcome to Q&A forum!

Are you currently deploying the Excel add-in centrally to users?
If so, per my research, not assigning an Exchange mailbox to the user may cause this issue.
Please download the Compatibility Checker and run the following steps, it will help provide more details about the exact issue.

Start an elevated PowerShell.exe window.
Run the following command: Import-Module O365CompatibilityChecker
Run the Invoke-CompatabilityCheck command: Invoke-CompatibilityCheck

This command prompts you for TenantDomain (for example, TailspinToysIncorporated.onmicrosoft.com) and TenantAdmin credentials (use your global admin credentials), and then requests consent.

For more details, please refer to: Determine if Centralized Deployment of add-ins works for your organization.
Any misunderstandings, please let me know.

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Erik Metzler 1 Reputation point

2021-08-30T18:21:51.413+00:00

Thank you. For clarity, we aren't deploying any central apps. The user wants to get AppFolio from the Office Store. But the only option is for Admin Managed.

I did try the compatibility checker, but sadly, it does not play well with admin accounts that have MFA enabled, and fails to authenticate.
Viki Ji_MSFT 4,466 Reputation points

2021-08-31T06:35:36.883+00:00

Hi @Erik Metzler ,
Thanks for you reply and certification.
Do you mean that you could access the Office Store normally when you sign in to the same computer with another account with the same licensing? Please try to sign in with the different account to confirm this.
If so, please sign in to another computer with the account that has this issue to check.
The above tests could help us determine whether it is an account problem or a program problem.

Besides, please go to File>Options>Add-ins to check if there are any other Add-ins enabled, if yes, please untick all of them.
And if there is a security software enabled, please turn it off temporarily.
If the above do not work, please tery to update your Windows.
And you could also try to create a new Windows account to check this issue.
Hope this issue could be resolved as soom as possible.
Please feel free to post back.
Erik Metzler 1 Reputation point

2021-09-03T23:26:17.913+00:00

I wasn't in a position to sign him in on another machine, or rebuild his windows profile.
I did find that the issue is the same in his online excel. He is unable to add add-in from the Office Store.
Is there by any chance a per user flag you can access via powershell that can enable/disable a user's access to the Office Store? (I'm fairly well versed in powershell with O365)
Viki Ji_MSFT 4,466 Reputation points

2021-09-06T08:54:05.077+00:00
Hi @Erik Metzler ,
Thanks for your reply and sharing.
Sorry that I am not a powershell expert. Thanks for your understanding.

Please open the Registry Editor and go to HKEY_CURRENT_USER>Software>Microsoft>Office>16.0>WEF\TrustedCatalogs to add the following key to check this issue.

Value Name disableomexcatalogs Value Type REG_DWORD Value 0

If I change the value to 1, the issue will be reproduced.

If the above do not work, please confirm the following information with us.

Are there any other error messages other than “No add-ins currently available”?

Do other Office apps(such as Word and PPT) have this issue?

You could also try the steps in this official article to check again.
Any updates, pleaselet me know.
Erik Metzler 1 Reputation point

2021-09-07T17:07:52.323+00:00

Thank you, but that did not resolve. I did test it on my system and confirmed that by setting to 1, I get the same experience. And setting to 0 for me will resolve. But on the users machine, it did not.

II tried to send the user directly to the store page for the app:
https://appsource.microsoft.com/en-us/product/office/WA104381541?src=office

When they tried to add it that way they got the following error.

I cannot however locate any sort of privacy settings that could account for the store being disabled for this user.
Viki Ji_MSFT 4,466 Reputation points

2021-09-08T10:05:39.887+00:00
Hi @Erik Metzler ,
Thanks for your reply.

Based on the above information, please check if the user can open the Microsoft Store app normally.

If it does not open normally, please try the steps in this page.

If it can be opened, this issue may be caused by an improper policy setting. But it does not rule out the problem of the user account. Please try to reset Excel:
Open the Registry Editor, go to HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0 to delete the Excel subkey. (Because deleting the registry key is irreversible, please back it up first.)

If none of the above works, it is recommended that you open a paid ticket with Microsoft Support to help you test remotely and further analyze this issue.
Thanks for your understanding!
Sebastian Cerazy 316 Reputation points

2025-04-29T09:01:26.7733333+00:00

This useless checker does not support MFA so it is UNUSABLE

Share via

User unable to see the Office Store in Excel (we have it enabled).

1 answer

Your answer