Document Editing Problems

How to Copy Excel Formulas from SharePoint to a Desktop Workbook

Adam DavisAdam Davis Nov 4, 2026 871 views

Question details

The user needs to copy cells containing formulas from an Excel for the web workbook hosted on SharePoint into a local desktop workbook, but only values or text are being pasted.

How to Copy Excel Formulas from SharePoint to a Desktop Workbook
Product
Microsoft Excel
Device & OS
not provided
Scenario
Copying cell contents between a SharePoint online workbook and a local desktop file.
Observed behavior
The destination workbook receives the calculated results or plain text instead of the original underlying formulas.
Before you start

Ensure you have the necessary permissions to open the SharePoint workbook in a desktop application, as using the desktop software for both files is the most reliable method for preserving formulas across workbooks.

Solution 1Recommended

Open Both Workbooks in the Excel Desktop Application

The most effective way to retain formulas when copying is to handle both files within the fully-featured desktop app rather than relying on the web browser clipboard.

Browsers often isolate clipboard data, causing complex structures like formulas to strip down to plain text when moving between web and local applications. Opening both files in the same instance of the desktop application bypasses this limitation.

1
Open source file in desktop

In your SharePoint document library or within Excel for the web, click the 'Editing' or 'Viewing' menu on the top ribbon and select 'Open in Desktop App'.

2
Open destination file

Once the SharePoint file opens in your local Excel desktop software, launch your destination local workbook within the same Excel application window.

3
Copy and paste formulas

Highlight the cells containing the formulas in the SharePoint file, copy them (Ctrl+C), switch to your local destination file, and paste them (Ctrl+V).

Open Both Workbooks in the Excel Desktop Application
Consistent Formula References: Pasting within the same desktop application session ensures that relative and absolute formula references are preserved accurately.
Free Microsoft Office alternative

Experience Seamless Formula Management with WPS Office

If you frequently struggle with copying formulas across different browser environments or lack a premium desktop Office license, WPS Office provides a free, lightweight, and highly compatible alternative. You can smoothly open, edit, and copy formulas between multiple local and cloud workbooks without data loss.

  1. 1. Install WPS Office: Download and install WPS Office on your computer for free.
  2. 2. Open Workbooks: Launch WPS Spreadsheets and open both your source and destination workbooks in the unified tabbed workspace.
  3. 3. Copy Without Restrictions: Easily copy and paste complex formulas between your spreadsheet tabs without losing formatting or experiencing web browser clipboard limitations.
Highly compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Robust formula and function support equivalent to standard spreadsheet software.Seamlessly open multiple workbooks in a single tabbed window for easy cross-copying.Free, lightweight, and quick to install on any major operating system.
microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel formulas paste as plain text from the web?

Excel for the web operates within your browser's clipboard constraints. When copying across different browser contexts or moving from web to desktop, the clipboard often falls back to pasting the calculated values or plain text instead of the complex underlying formula structure.

Can I copy a formula without changing its cell references?

Yes. To keep exact cell references without them shifting automatically, copy the actual text of the formula directly from the Formula Bar at the top rather than copying the cell itself, and then paste it into the new cell's Formula Bar.

Does the 'Paste Special' option work in Excel for the web?

Excel for the web does support 'Paste Special', but its functionality is more limited compared to the desktop app. Pasting formulas specifically might still fail if the workbooks are opened in entirely separate web sessions or tabs.

How can I link cells between two workbooks in Excel online?

Currently, Excel for the web has highly restricted support for external workbook links. To reliably create and maintain links or cross-workbook formulas, you need to open the files using the standard desktop application.