Copy and paste spread sheet
 

Is there anyway I can copy a spreadsheet from fileA.xls to fileB.xls
without creating the link (in formula) to fileA ?

I am using excel 2000.

Thanks

Copy and paste spread sheet
 

If you want to replace your formulas with the value they display
cells.Value = Cells.Value

if you have identical source data in the destination sheet and you change
the source
See changelink

ActiveWorkbook.ChangeLink "c:\excel\book1.xls", _
"c:\excel\book2.xls", xlExcelLinks

--
Regards,
Tom Ogilvy


"broogle" wrote in message
ups.com...
Is there anyway I can copy a spreadsheet from fileA.xls to fileB.xls
without creating the link (in formula) to fileA ?

I am using excel 2000.

Thanks

Copy and paste spread sheet
 

Thanks Tom!!