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.

Highlight the data in the 'Imported Data' worksheet.
USING THE DELETE KEY ON THE KEYBOARD, hit 'DELETE'.
This will get rid of the data BUT leave the references that you have in the
'Reformatted Data' worksheet.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Grey Old Man" wrote:

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.