Fix "Your Administrator Has Blocked This File Type" Error in Excel
Question details
The user is unable to open specific Excel workbooks because the application displays an error message stating that an administrator has blocked the file type.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Trying to open downloaded files, workbooks containing macros, or older legacy spreadsheet formats on a personal computer.
- Observed behavior
- Excel blocks the file from opening and throws an administrative security restriction error, even if the computer only has a single personal user account.
Verify that the Excel file you are trying to open comes from a trusted and reliable source, as bypassing file-block restrictions for malicious files can compromise your system's security.
Adjust File Block Settings in the Trust Center
Modify Excel's built-in security settings to unblock specific file types or macro-enabled workbooks.
Microsoft Excel includes a Trust Center that restricts certain outdated or potentially dangerous file types by default. If you trust the file, you can temporarily or permanently bypass these restrictions.
Launch Microsoft Excel, click on the 'File' tab in the top-left corner, and select 'Options' at the bottom of the menu.
In the Excel Options dialog box, select 'Trust Center' from the left-hand pane, then click the 'Trust Center Settings' button on the right.
Click on 'File Block Settings' in the left menu. Locate the file type you are trying to open and uncheck the 'Open' and 'Save' boxes next to it.
Click 'OK' to save your changes and exit the Trust Center. Try opening the blocked Excel file again.
Disconnect Work or School Accounts
Remove organizational accounts from your Windows settings that might be imposing strict security policies on your personal device.
Address Corrupted Microsoft Account Profiles
Fix administrative errors caused by a corrupted personal Microsoft account or out-of-sync Office 365 licensing.
Open Your Spreadsheets Seamlessly with WPS Office
If Microsoft Excel's strict security policies, corrupted account profiles, or administrative errors are preventing you from accessing your own files, try switching to WPS Office. It provides a highly compatible spreadsheet editor without the hassle of restrictive account policies.
Frequently Asked Questions
Why am I getting an administrator block on a personal computer?
This usually happens when Excel's Trust Center applies default restrictions to legacy or macro-enabled files. It can also occur if your PC is connected to a work or school email account in Windows settings, which silently applies organizational security policies to your personal machine.
How do I unblock macros for a specific Excel file?
To unblock a specific file, right-click the file in Windows File Explorer, select 'Properties', and look at the bottom of the 'General' tab. If you see a 'Security' section stating the file came from another computer, check the 'Unblock' box and click 'OK'.
Can a corrupted Microsoft account cause file blocking in Excel?
Yes. In rare cases, a glitch or corruption within your personal Microsoft account (such as a Hotmail or Outlook account) can confuse Office's licensing and security checks, causing it to display false administrator restriction errors.
Are files blocked by the Trust Center actually dangerous?
Not always, but they carry a higher risk. The Trust Center blocks older formats (like Excel 95/97 files) and macro-enabled workbooks because they can be exploited by malware. If you downloaded the file from an unknown website, it is safer to leave it blocked.
