Copy a file with only values no formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lee Coleman - 06 Apr 2007 16:26 GMT

Is there an easy way to copy a workbook so that it only has the values and
not the formulas?
Thank you.

Signature

Lee Coleman

Reply to this Message

Bob Flanagan - 06 Apr 2007 16:30 GMT

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

> Is there an easy way to copy a workbook so that it only has the values and
> not the formulas?
> Thank you.

Reply to this Message

Lee Coleman - 06 Apr 2007 16:43 GMT

Thanks! I knew there had to be an easier way than I was trying to do it.
Thanks again.
Lee

> 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
[quoted text clipped - 9 lines]
>> and not the formulas?
>> Thank you.

Reply to this Message