How do I stop Excel from trying to upload a file to a server I only have read access to?

Question

How do I stop Excel from trying to upload a file to a server I only have read access to?

Jolyon Hawley 0

I download an Excel file each week from a PowerBI application on a government server. I only have read-only access to the server, and the intention is to keep the file as a snapshot at that point in time. However, Excel opens the file as read-only and keeps trying to "merge changes with other users" and attempts to upload the file back to the server when I close it. I want the file to be a static snapshot, not updated, and I certainly don't want to be trying to upload a file to a read-only server. How do I turn the file into a local-only static file?

4 answers

Your answer

Answer 1

Dear @Jolyon Hawley,

Thank you for reaching out to the Microsoft 365 Q&A forum. I understand how frustrating it is when Excel tries to be "too helpful" by treating a downloaded report like a live, collaborative document especially when you just want a clean, local snapshot.

The behavior you're seeing happens because the file contains metadata linking it back to its original SharePoint or OneDrive source. Even though you only have read-only access, Excel’s "AutoSave" and "Sync" features attempt to check for updates or merge changes by default.

To help me narrow down the cause, could you please provide the following details?

Can you confirm if the file is being saved successfully in a local directory?
Are there any specific settings in Excel that you know of that might be set to auto-upload?
Is there any error message you receive when trying to close the file?

In the meantime, please try the following official troubleshooting steps which usually resolve issues with basic issues:

Step 1: Use "Save a Copy"

The most reliable way to strip the server connection is to create a fresh local version before you start working.

Open the file from your downloads.
Go to File > Save a Copy (or Save As).
Choose a location on your local hard drive (e.g., your Desktop or a local folder) rather than a synced OneDrive/SharePoint folder.

Crucial: Rename the file slightly. This forces Excel to treat it as a new entity independent of the server's version history.

Step 2: Disconnect the "Shared Workbook" Metadata

If the file is stubbornly trying to "merge changes," it might have legacy sharing settings enabled.

Go to the Review tab in the top ribbon.
Look for the Protect group.
If you see Unshare Workbook, click it. (Note: In newer versions of Excel, this is often handled by the "Catch Up" or "Changes" button near the top right; clicking "Disconnect" there can also stop the sync attempts).

Step 3: Change the File Extension

If the file persists in trying to talk to the server, saving it in a different format usually strips all background web metadata.

Open the file.
Go to File > Save As.
In the file type dropdown, change it from .xlsx to Excel Binary Workbook (.xlsb) or CSV (if you don't need formatting).
Save it, close it, and then save it back to .xlsx if you prefer. This process often "washes" the file of its original server instructions.

Step 4: Adjust Excel Trust Center Settings

To prevent Excel from automatically trying to sync web-based files in the future:

Go to File > Options > Trust Center > Trust Center Settings.
Select Protected View.
Ensure "Enable Protected View for files originating from the internet" is checked.
This will force Excel to keep the file in a "sandboxed" state until you explicitly choose to edit it, preventing background upload attempts.

Step 5: Prevent Automatic Opening of Server Files

If Excel is still trying to connect to the server, you can also start Excel in safe mode:

Hold down the CTRL key when launching Excel; this prevents add-ins and any auto-start files from loading.

For further detailed troubleshooting on Excel, you may refer to the official

How to troubleshoot errors when you save Excel workbooks - Microsoft 365 Apps | Microsoft Learn

How to prevent files from opening automatically in Excel - Microsoft 365 Apps | Microsoft Learn

Please note that as a forum moderator, I don’t have access to backend tools or internal systems to investigate further, and certain settings or configurations are managed exclusively by your organization’s administrators, so I’m unable to check or make changes on that side. That said, I truly hope these suggestions help you move forward.

Please let me know if you have any further questions or if the problem persists after trying these solutions. Thank you for your patience and cooperation.

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.

Sophie N 12,655 Reputation points Microsoft External Staff Moderator

2026-02-10T03:07:31.3666667+00:00

Dear @Jolyon Hawley,

I hope you’re doing well. I just wanted to check in and see how things are going with the steps I shared earlier. If you ran into any difficulties at any point or if something is unclear, please don’t hesitate to let me know. I completely understand that these processes can sometimes be tricky, and I’m here to make it as easy as possible for you.

Feel free to share any details or questions you might have, I’m ready to listen and assist you further.

Answer 2

kagiyama yutaka 1,245

excel tries to talk back to the source if any collab bits survived… i just save‑as to a dumb local path right away, it cuts the wire clean. if it still nags, that’s the old shared‑wb flag hanging around… gov exports leave that half‑alive a lot i think.

Sophie N 12,655 Reputation points Microsoft External Staff Moderator

2026-02-15T00:04:48.63+00:00
Dear @kagiyama yutaka,

Thank you for pointing out that comment. I understand why it sounds confusing, so I’d like to explain what it means in a clear and practical way. When the commenter says that “Excel tries to talk back to the source,” they mean that an Excel file can retain hidden collaboration or sharing information from where it originally came from (for example, OneDrive, SharePoint, a shared network drive, or a government/enterprise export system). Even after downloading the file, Excel may still behave as if it is connected to that original source.

By using Save As to a simple local folder (what they called a “dumb local path,” such as the Desktop or C:\Temp), Excel is forced to create a brand‑new copy of the file. This effectively cuts any remaining connection to the original shared or cloud location and often stops repeated prompts, warnings, or sync‑related messages.

The reference to the “old shared‑workbook flag” relates to a legacy Excel sharing feature. In some cases, especially with exported files this setting can remain partially active in the file even though it no longer appears to be shared. When that happens, Excel may continue showing warnings or unusual behavior.

In simple terms, the advice is saying:

Use Save As to a local folder to remove hidden sharing or collaboration metadata.

If Excel still shows messages after that, the file may contain leftover legacy sharing information.

This behavior is more common with exported or transferred files than with files originally created locally.

I hope this helps clarify what the comment means and how it applies to your situation. Please let me know if you’d like help checking or cleaning up sharing settings in the file.

Answer 3

Jolyon Hawley 0

This seems to have worked, although the new file initially couldn't be seen in the browser until I synced with OneDrive
Wasn't applicable
This did not work. Opening the file from the local copy still tried to sync back to the server
Not applicable.

It would be better if files downloaded from a read-only server had this sync functionality turned off, or if there was some way to turn it off.

Answer 4

To prevent Excel from trying to upload a file to a server where you only have read access, you can follow these steps to ensure the file remains a static snapshot:

Save the File Locally: After downloading the file from the PowerBI application, make sure to save it to your local drive. You can do this by using the "Save As" option in Excel and choosing a location on your computer.
Disable Auto-Save and Sharing Features: Ensure that any auto-save or sharing features are disabled. You can do this by going to the Excel options and turning off any settings related to sharing or syncing with cloud services.
Open the File Directly: Instead of opening the file from the server, open it directly from your local drive. This should prevent Excel from trying to merge changes or upload the file back to the server.
Check for Protected View: If the file opens in Protected View, you can enable the "Open Office documents as read/write while browsing" policy setting to avoid issues with editing.

By following these steps, you should be able to maintain the file as a static snapshot without any attempts to upload it back to the server.

References:

Share via

How do I stop Excel from trying to upload a file to a server I only have read access to?

4 answers

Your answer