How to Copy Excel Formulas from SharePoint to a Desktop Workbook
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.

- 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.
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.
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.
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'.
Once the SharePoint file opens in your local Excel desktop software, launch your destination local workbook within the same Excel application window.
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).

Enter the Formula Manually in Excel for the Web
If you do not have access to the desktop version of Excel, you will need to copy the formulas directly as text from the Formula Bar.
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. Install WPS Office: Download and install WPS Office on your computer for free.
- 2. Open Workbooks: Launch WPS Spreadsheets and open both your source and destination workbooks in the unified tabbed workspace.
- 3. Copy Without Restrictions: Easily copy and paste complex formulas between your spreadsheet tabs without losing formatting or experiencing web browser clipboard limitations.

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.




