Right click on a sheet tab and select all sheets. Then select all cells on
the active sheet. Do a copy, then Edit, paste special, values. Right click
on a sheet tab and select ungroup sheets. Save the workbook under a
different name!!!!

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel



"Lee Coleman" wrote in message
...
Is there an easy way to copy a workbook so that it only has the values and
not the formulas?
Thank you.

--
Lee Coleman