This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Starting this morning, 01May2019, my team has been unable to paste values (from a calculated formula) from the online browser version of Excel into any other file. The paste action will only let us paste the original formula and it will only allow two options for pasting, both formatting. I have tried pasting into another Excel file in Sharepoint, into an Excel file on my PC, into a word doc in S.P., and into a word doc on my PC, none of these allow for pasting the values. See images below, I am using "0" values to keep our data confidential.
We have never had this issue until today. Our workaround is to download the Excel file and copy and paste from the downloaded file, which is annoying because we then cannot update the shared Excel file after performing the copy and paste actions.
Any suggestions or information would be appreciated. Thank you.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I tried to copy and paste this morning and everything works as normal today. It seems Sharepoint was able to sort itself out overnight. I can copy from a calculated cell and paste the value into any other file.
Hi Jacob,
Thanks for the update. Glad to hear it. If there are any questions again, welcome to post in our forum.
Regards,
Alex