Excel 2003. Re-use a spreadsheet?
 

I want to delete all the data but keep the formulas. I made a copy of the
original workbook and cleared the data but now I have no formulas. What did I
do wrong?

Excel 2003. Re-use a spreadsheet?
 

hi
not sure how you cleared the data but you may have deleted the formulas too.
try this......
make a copy of the original workbook again. in the new copy, hit the f5 key
to bring up the goto dialog. click the special button at the bottom. on the
special go special dailog, click contraints the ok.
all non formula data should be high lighted. delete.
data should be gone. formulas remain.


Regards
FSt1


"MollyO" wrote:

I want to delete all the data but keep the formulas. I made a copy of the
original workbook and cleared the data but now I have no formulas. What did I
do wrong?

Excel 2003. Re-use a spreadsheet?
 

Great! Thanks for the replies. I will attempt this soon and see how it goes.

Molly



"Roger Govier" wrote:

Hi Molly

You should have pressed F5SpecialConstantsOKDelete

--
Regards
Roger Govier

"MollyO" wrote in message
...
I want to delete all the data but keep the formulas. I made a copy of the
original workbook and cleared the data but now I have no formulas. What
did I
do wrong?