In article <
dfbfde2b-5bba-475b...@googlegroups.com>, David
Michael wrote...
>
> bump
I can't make any sense of your question. Just be selective in what you delete?
What situation prompts that question?
Trying to unpack: I infer that you have data (constants?) in a cell which
contains a formula. If so, try moving the constants to a dedicated worksheet,
and name the ranges. Simple example: I have a spreadsheet which tracks my
alcohol consumption units (medical necessity, sadly). I have a named range
called "PINT", and I refer to it in a cell as '=PINT'. The named range PINT
contains the value 568. There are other ranges called 'BOTTLE' and
'HALFBOTTLE'. If someone in the USA wanted to use my spreadsheet, they could
edit PINT to 473.
Throughout IT, it's beneficial to keep raw data independent from operations
which derive from that data, and similarly from formatting markup. The
benefits of this increase with the scale of the project.
--
Phil, London