Andreas,
This could be done with code but over the years I have learned that the quickest and simplest way, once you've done it a couple of time is the following.
Replace all the "=" with "#=" to turn the formulae into text and then create a copy of the sheet and in the...