I am writing an Excel 2002 template, and wish to convert a large range of
imported data.

All of my formulae have been written in row A on a €˜Reformatted Data sheet.
For example cell A1 contains =TEXT('Imported Data '!B3,"00").

The many formulae work successfully, but I need to delete the entire
contents of the €˜Imported Data sheet. As a template it needs to be empty.

Obviously the formulae in my example cell is now =TEXT('Imported Data
'!#REF!,"00") because of the invalid cell reference.

My question is, how do I retain the formulae in the template? Or do I have
to use the ISERROR function on all of them?

Thanks in anticipation.