SharePoint Document Issues

How to Fix Excel Virus Warning When Opening SharePoint Files

Amos Gikunda Oct 20, 2026 868 views

Question details

Users receive a virus warning when attempting to open Excel files stored on a SharePoint site, preventing normal file access.

How to Fix the Excel Virus Warning When Opening SharePoint Files

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening a shared Excel spreadsheet hosted on a SharePoint directory.
Observed behavior: Excel displays a security warning stating the file could contain viruses, even though other users with identical permissions can open the same file without warnings.

Before you start

Verify with your IT administrator that the specific SharePoint URL you are accessing is legitimate and safe before adding it to your system's trusted locations.

Solution 1Recommended

Add the SharePoint Site as a Trusted Location in Excel

Configuring Excel's Trust Center to recognize your SharePoint URL prevents false positive virus warnings and bypasses strict Protected View restrictions.

By default, Excel's security settings treat network locations and internet URLs as potentially unsafe. Adding your organization's SharePoint site to the Trusted Locations list tells Excel to skip the virus scan and open the file normally.

Open Excel Options

Launch Microsoft Excel. Click on the 'File' tab in the top-left corner of the ribbon, and select 'Options' from the bottom of the left-hand menu.

Access the Trust Center

In the Excel Options dialog box, click on 'Trust Center' in the left pane, and then click the 'Trust Center Settings' button on the right.

Navigate to Trusted Locations

Select 'Trusted Locations' from the left menu in the Trust Center window, then click the 'Add new location' button near the bottom.

Enter the SharePoint URL

Type or paste the main URL of your SharePoint site into the Path field. Check the box labeled 'Subfolders of this location are also trusted' if applicable, click 'OK', and restart Excel.

Add the SharePoint Site as a Trusted Location in Excel

Network Locations Setting: If the 'Add new location' button is greyed out for network paths, ensure you check the box that says 'Allow Trusted Locations on my network (not recommended)' at the bottom of the Trusted Locations window.

Free Microsoft Office alternative

Edit Spreadsheets Securely and Easily with WPS Office

If you are tired of dealing with complex Trust Center configurations and persistent security warnings in Microsoft Excel, WPS Office offers a lightweight, highly compatible alternative for opening and editing your spreadsheets.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Launch WPS Spreadsheets: Open the WPS Spreadsheets application on your computer.
3. Open Your File: Click 'Open' and select your downloaded Excel spreadsheet to view and edit it instantly.

Fully compatible with Microsoft Excel formats, including .xlsx, .xls, and .csv.Lightweight and fast to launch without complex trust center configurations.Familiar user interface for a seamless transition from Microsoft Office.Free to download and use for your daily document and spreadsheet needs.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel show a virus warning for my SharePoint files?

Excel utilizes a feature called Protected View to flag files originating from the internet or network paths, including SharePoint. This acts as a security measure to protect your computer against potential malicious macros or embedded code.

Do I need administrator rights to add a trusted location in Excel?

Usually, you can add personal trusted locations in the Trust Center without administrator privileges. However, if your organization manages these settings via Group Policy, the option might be disabled, and you will need to contact your IT department.

Can I just disable Protected View entirely?

While it is possible to disable Protected View for all internet and network files in the Trust Center, it is highly discouraged. Doing so bypasses essential security checks and leaves your computer vulnerable to actual malware.

How do I safely share SharePoint Excel files without triggering warnings for my team?

You can encourage your team to collaborate using Excel for the Web (the browser version), which bypasses local Trust Center warnings. Alternatively, request your IT administrator to push a Group Policy update that whitelists the SharePoint URL as a trusted site for the entire organization.

Document & File Issues