File - -> Save As - - > Values
In my current project I need to have a Data file with all my formulae and a report file containing only the values minus the formulae.
My suggestion is that instead of copying data and pasting as Values or using VBA scripts, can we have a Save As Value file? This would make it very easy to only save the contents/values of a file and while keeping the original one intact.
Currently files loaded with formulae take forever to open and filter. Copy pasting works but that's a few extra steps. If there was a direct way it would make it super easy. I know there are 3rd party tools available but they cannot be used at my workplace.