Paste and paste special not working as previously in Excel Office 365

Hi V. Arya,

Yes it is v16.37. sorry about that.

Thanks D  

There are 2 Paste Special dialogs: The one in your screen shot & the one you are expecting to see. Which one is presented is determined by how Excel recognizes the content on the macOS Clipboard.

Normally only valid worksheet content calls up the one you're looking for. Otherwise, (such as with content copied from a word processing program or other source) you get the one you are seeing. Apparently what you are copying is not being recognized as workbook content.

Do you happen to have a clipboard management utility installed such as CopyPaste Pro, Copy'em Paste, Clippy, CopyClip 2, etc.? Many of them cause such interference, especially if they are not fully updated.

Hi Bob,

No i don't have any clipboard management software installed.

But i agree that it does seem to be a problem somehow associated with clipboard. I considered installing some clipboard management software to see if it actually fixed the problem, but haven't done that yet until i see if this thread helps. 

I have a similar problem with Word ... which used to show "paste as bitmap, paste as PDF" and a few others i can't remember. And now i notice it has this: 

Quick update... 10 mins later: 

I just downloaded CopyClip to see if this fixed the problem, and it did not. I still have exactly the same issues. 

Bummer... 

I have this same problem. It started approximately 1 week ago (June 15-ish). I do have some minor differences/additions:

1) I have updated Excel to 16.38 and the problem persists

2) I have not installed a clipboard manager

3) Dragging to fill adjacent cells does correctly copy the formulas

4) Copying a cell with a formula to multiple cells (e.g., copy A1 to A2:A5) generates the alert "The data you're pasting isn't the same size as your selection. Do you want to paste anyway?" Confirming the paste should occur (clicking "OK") only pastes to the first cell of the selection and the result is the text of the resolved formula.

This is a very significant issue for large spreadsheets where formulas are abundant. Hopefully there will be a resolution soon. 

I am using a MacBook Pro with MacOS 10.15.4 (Catalina). Also installed are Netskope Client, Forcepoint One Endpoint DLP. Not that these additional tools are a corporate mandate and were installed prior to this occurrence of this issue. I mention them, however, because there could have been an update applied to either of them that I would not know about or have control over.

Thanks for any help that can be provided.

Ed Price

Hello,

I had a similar problem in that the paste (ctrl v) would paste the value from the cell I had copied; but when looking at the cell it showed the correct formula. 

After some searching I found that somehow the 'Workbook calculation' in the 'Excel Options' had been changed to 'Manual'.

To fix the problem I went to 'File" in Excel, selected "options".

The selected 'Formulas'.

Then changed Workbook calculation to 'Automatic'.

Using Excel 2010 and Windows 10. Have no idea how it got change to manual calculation in the first place!

jim s1234 thanks for the idea of where to look for a resolution. unfortunately, following the similar steps for a Mac did not solve the problem. Actually, Workbook Calculation was already Automatic. Changing to Manual and then back didn't fix it either.

Very frustrating and irritating. 

Yours is a different known issue probably related to the Forcepoint software:

Excel Copy/Paste not functioning on Mac