Hi --
I often have files with a summary sheet that calculates data from multiple local sheets. Some of the detailed data on those sheets can't be shared and are deleted before sending out the file to a wider audience.
I'm hoping there's a way to break the links on the summary sheet without having to go the copy/paste values option because I'd still like the local sum formulas to exist and Excel doesn't allow you to copy/paste multiple sections at the same time (& it'd be too tedious to copy/paste each section separately).
My current move is to transfer the sheet to a blank document, break the links, then move back. Though, I'd rather not have to do this each time if there's a more seamless route.
Thank you!
Bookmarks