my excel sheet is being constantly blocked!

Question

my excel sheet is being constantly blocked!

Iulia Pintrijal 20

I have been having this issue for months now but my patience is running thin. I am paying for a business license to be able to use Python on excel. This way, I got an email address with @onmicrosoft.com. I am logged in in my excel. I did go to trust center and gave all the permissions. One day it works, next day it doesnt....for months! I dont have any "unblock" button in the file properties.

It tell me that my file is a security risk even though its created on my PC. It tells me upload is blocked cause they are not sure i have permission and i should sign in. When i try to sign in, tells me i cant use a work or school account even though is A BUSINESS ACCOUNT. So i log in with the personal one...works util the first save. And no, i dont have autosave on either. Like i have tried everything. Can someone please give e a proper answer as to why this is still happening, please?

Thank you!

Accepted answer

0 additional answers

Your answer

Answer 1

Good day @Iulia Pintrijal

Welcome to Q&A forum!

Thank you for bringing this to our attention. I agree that it's unacceptable for you to encounter inconsistent behavior despite having a business account.

To make sure we're on the same page, please confirm a few things so I can address your issue correctly:

Could you provide the exact error message related to the "security risk" in your Excel file? (If possible, you can share screenshots to help me understand the issue better.)
Does this issue occur only with this specific Excel file, or does it happen with other files as well? (You can try creating a new file to see if the problem continues.)

During the confirmation period, I’d also like to share a few troubleshooting steps to see if they help resolve the issue. Let’s work together to identify the root cause and find the best way to support your use of Python in Excel.

1. Update Excel

To get started, please log in to your business account
Go to File -> Account -> Update Options -> Update Now.
Make sure you’re on the latest version — Python in Excel is still evolving and updates often fix bugs.

You can see the latest update for Excel here: Release notes for Current Channel

2. Start Excel in Safe Mode:

Press Windows Key + R to open the Run dialog.
Type: excel /safe
Press Enter.

Excel will open in Safe Mode. Try opening your Python-enabled file and see if the issue persists.

Start Excel in Safe Mode - Microsoft Support

3. Check File Location

In Excel, go to "File" -> "Save As".
You’ll see a list of locations:
- OneDrive & Your Company Name → This is your business cloud storage.
  - This PC - This is your local computer.

If your file is already saved, Excel will show the current location at the top of the Save As window.

User's image

3. Clear cached Credentials

First, you need to sign out all accounts in Excel

Go to File -> Account.
Click Sign out from all listed accounts.
Close your Excel completely.

Open Windows Credential Manager:

Press Windows Key + S, type Credential Manager, and open it.
Go to Windows Credentials.
Click on any entries related to: MicrosoftOffice, Excel, OneDrive, your @onmicrosoft.com or your personal account, etc and choose Remove
Credential Manager in Windows
After that, you can use only your @onmicrosoft.com business account.
Make sure it shows as licensed under “Product Information.”

4. Check Your License Type

Just in case your license wasn't assigned correctly to your business account.

Visit My account
Confirm that your business account has a Microsoft 365 Business Standard or higher license.

(Please understand that while we may not be able to resolve your issue in our initial response, but we’re committed to working with you to clarify the situation and provide as much support as possible.)

Looking forward to hearing from you!

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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. User's image

Iulia Pintrijal 20 Reputation points

2025-08-09T18:57:07.1266667+00:00

Hello, i followed all the steps above, then i opened the excel, the macro were blocked and the =PY was working. Then i tried to save and again its talking about credentials. I am uploading a picture - I am already signed in. I noticed a text in arabic, i dont know what that is, maybe its helpful for you. I hope the pictures get displayed.
I am attaching also smth just came to mind. When i installed my windows a couple of months ago, i used my business mail as microsoft account...and then i purchased the excel license that got me this onmicrosoft.com account. I dont know if its relevant.

Thank you for trying though. I am not sure what else i can do to make it work.

Iulia.
Alina-Le 1,040 Reputation points Microsoft External Staff Moderator

2025-08-11T14:31:43.53+00:00

Hi @Iulia Pintrijal

Thank you for your update. Unfortunately, I still can't see the image, could you kindly try inserting it again?

Before we receive your error message image, based on the information you've provided, since you used your business email to set up Windows and later received a separate @onmicrosoft.com account. Excel might be confusing the two identities, especially if both are linked to Microsoft services. This could cause Excel to mistakenly think you're not authorized, even though you are.

While waiting for your image, I suggest that you try to do these steps to see if it helps your situation.

Step 1: Fully Sign Out of All Microsoft Accounts

Open Excel and go to File -> Account.

Click Sign out from all accounts listed.

Open Windows Settings -> Accounts -> Email & Accounts.

Remove any personal Microsoft accounts listed under “Accounts used by other apps.”

Restart your PC.

Step 2: Sign In Only with Your Business Account

Open Excel and sign in using only your @onmicrosoft.com account.

Make sure it shows as Work or School Account under File > Account.

Check that your license is active under File -> Account -> Product Information.

Step 3: Repair Office via Control Panel

This is the easiest and safest way to reset Office settings.

Close all Office apps (Excel, Word, Outlook, etc.).

Go to Control Panel -> Programs -> Programs and Features.

Find Microsoft 365 Apps for Business or Microsoft Office in the list.

Click Change.

Choose Online Repair (not Quick Repair) and follow the prompts.

This will reset Office to its default settings and reinstall missing or corrupted components. Your files and license will remain intact.

Looking forward to hearing from you!

Share via

my excel sheet is being constantly blocked!

0 additional answers

Your answer