Copy/Pasting Formulas Using Notebook

Occasional Visitor

Hello, I'm having trouble copying formulas into Notebook (for pasting back into Excel without any changes). Usually I CTRL + ~ to see all the formulas in a sheet, CTRL + C, CTRL + V in Notebook which pastes the formulas, and CTRL + C/V back into Excel in a new sheet/a few columns over/etc. to keep the formulas the same when it's not practical to lock all the cells.

 

Recently, rather than pasting the formulas, only the values are pasted in Notebook (I confirmed it's just values because that's how it's pasted back in Excel). Was there an update that changed this? Is there a way to revert this setting and/or achieve my original goal? Thanks!

 

 

0 Replies