Good morning everyone,
I'm a newbie and using Excell 2007.

I would like to know how to remove all formulae and/or functions (and codes
when I will have some) from previously saved worksheets, to leave me with
just the values and, possibly, the colour coding in some cells when there are
some.

I would like to apply this to all my saved worbooks (saved in folders) so
that I am left with data only, be it numeric or text; the saved files are
mainly used for checking against the current working sheet and there is no
need for further calculations on those.

I thought that by doing this, I would be saving valuable computer speed, to
be used on my current worksheet/worbook.

Is this correct and can I do this?

Thank you for your help
Cat