Invalid cell reference
in [General]
|
Prev: No more fonts maybe applied to this work book, Why????
Next: forgot to attach doc sent via email, original's not saved. can it.
From: Grey Old Man on 26 Apr 2010 09:42 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.
From: Gary Brown on 26 Apr 2010 09:47
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. > |