Office 365 Mac - Excel - Copy & Paste Problem

Question

I am running excel office 365 on a Mac 

This previously worked as expected, select a cell or cells, copy, select new location and paste formula contents into new location.

I started having problems with copy and paste functionality: when I am copying a cell that has a formula and I paste it into a new location, only the values are populated in the new cell location.

the behavior exists when using:

• Mouse clicks
• Keyboard Shortcuts
• Edit menu

visually when I perform the copy operation, the border(s) of the cell(s)  being copied are momentarily highlighted with the rotating dashed line and then the border just goes back to the selected outline.

I can successfully copy the formula from the formula bar and paste it into a new location.

• this is a more literal copy and paste and none of the referential location information is updated after this operation.

I did some googling and tried various solutions to clear the clipboard cache and verify the calculation option was set to automatic vs. manual, but the problem persists.

I don't have any macros stored in a Personal Macro Workbook.

I performed an uninstall and re-install of excel and issue still exists

I found that when using the method described in this article to select and drag the selected cells to a new location works for the use case to copy cells within a worksheet.

https://support.office.com/en-us/article/move-or-copy-cells-rows-and-columns-3ebbcafd-8566-42d8-8023-a2ec62746cfc

Answer 1

I'm having the same issue. I am not running any 3P clipboard management tools. When I run in safe mode, it pastes correctly, but rebooting in normal mode, only the values paste and not the formulas.

Answer 2

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.

Are there any copy/paste issues with other programs?

Two troubleshooting tests:

• Create a new Standard User Account on your Mac. Log in as that user then launch Excel to see whether the issue is present.
• Start your Mac in Safe Mode to see whether the issue persists.

Answer 3

sorry, I meant to respond to this earlier ... 

IT implemented an endpoint security application that broke the excel referential clipboard functionality.  

a patch was created and distributed by IT organization.