'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel for the Web Cannot Paste Formulas from a Local Workbook
Question details
Users are unable to copy formulas from a local offline Excel workbook and paste them into Excel for the web.
- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- Copying data that contains formulas from an offline desktop Excel file and pasting it into an online Excel spreadsheet in the browser.
- Observed behavior
- The Paste with Formulas option is unavailable, and formulas are stripped out, pasting only as plain text or values.
Ensure you have an active internet connection and are signed in to your Microsoft account, as you will need to access OneDrive to resolve this compatibility limitation.
Upload the Local Workbook to OneDrive (Recommended)
By uploading your local workbook to the cloud and opening it in Excel for the web, you allow both documents to share the same web clipboard, preserving formulas during the copy and paste process.
Modern web browsers have strict security limitations regarding the system clipboard. When you copy complex data like Excel formulas from a desktop application, the browser cannot interpret the formula logic and automatically downgrades the data to plain values. To bypass this, both the source and destination workbooks must be opened within the web environment.
Log into your OneDrive account through the web browser, click the 'Upload' button, and select your local Excel workbook to upload it to the cloud.
Once the upload is complete, click on the file in OneDrive to open it in a new Excel for the web tab.
In the online version of your source workbook, select the cells containing the formulas you need, and press Ctrl+C (or Cmd+C on Mac) to copy them.
Switch back to the tab with your destination workbook in Excel for the web, select the target cell, and press Ctrl+V to paste the formulas intact.
Sign Out and Sign Back In to Refresh Your Session
If you have already uploaded your workbook to OneDrive but the paste formula option is still missing, your Microsoft session might have encountered an authentication error.
Use WPS Office to Seamlessly Edit and Copy Formulas Across All Files
Avoid frustrating browser clipboard limitations altogether. WPS Office is a free, powerful desktop suite that allows you to open, edit, and smoothly copy formulas between any local and cloud workbooks without functionality restrictions.
- 1. Install WPS Office: Download and install the free WPS Office desktop application on your computer.
- 2. Open your workbooks: Open both your source and destination spreadsheet files simultaneously within the WPS Spreadsheet application.
- 3. Copy and paste with ease: Select the cells with your formulas, copy them, and paste them directly into the target workbook without any browser restrictions.
Frequently Asked Questions
Why does Excel for the web paste values instead of formulas from my desktop?
Web browsers employ security sandboxes that prevent web applications from directly accessing complex objects on your computer's system clipboard. When you copy a formula from a desktop app, the browser can only read the plain text or calculated value, resulting in a loss of the actual formula.
Can I paste formulas between two Excel desktop workbooks?
Yes, desktop applications have full access to the system clipboard. If you open both workbooks in a desktop version of Excel or a compatible alternative like WPS Office, you can copy and paste formulas seamlessly.
How do I retain formulas when uploading a local workbook to OneDrive?
Uploading a file to OneDrive automatically retains all data, including formulas. Simply use the 'Upload' button in OneDrive. Once uploaded, open the file in the web browser, and you will be able to view and copy the original formulas.
Are there keyboard shortcuts for pasting formulas in Excel for the web?
Yes. When copying between two workbooks that are both open in Excel for the web, you can use standard shortcuts like Ctrl+C to copy and Ctrl+V to paste. If you need special pasting options, you can right-click the destination cell and select 'Paste Formulas' from the Paste Options menu.
