Invalid cell reference

[Grey Old Man]

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.

 

[Gary Brown]

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.