Copy a file with only values no formulas

  • Thread starter Thread starter Lee Coleman
  • Start date Start date
L

Lee Coleman

Is there an easy way to copy a workbook so that it only has the values and
not the formulas?
Thank you.
 
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
 
Thanks! I knew there had to be an easier way than I was trying to do it.
Thanks again.
Lee

Bob Flanagan said:
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
Click to expand...
 
Back
Top