One method....

F5SpecialFormulasOK

EditReplace

What: =

With: ^^^

Replace all.

Copy to the new workbook/worksheet and then reverse the process of EditReplace.


Gord Dibben MS Excel MVP


On Tue, 11 Dec 2007 15:54:01 -0800, PJ in CO <PJ in
wrote:

Is there a way to copy a Excel file with just formulas (not data) and apply
it to another file w/o the copied file link included? I have a program which
spits out a xls file for each data set generated and I'd like to manipulate
the data repeatedly for each file w/o having to generate the doggone formulas
each time. Thank you