Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Copy/Pasting Formulas Using Notebook

Copper Contributor

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