Thanks for your reply.

However, by copying values, it will lose all the color and format from the
original worksheet. I would like to save it as another Excel file, with the
format, color, data value, without the formula that import the data from
external source.

Is there a feature like that?

skysusan

"Gord Dibben" wrote:

On a copy of your original workbook.

Select all sheets by right-click on a sheet tab and "select all sheets".

CTRL + a(twice in 2003) to select all cells on all sheets.

Copy then in place.........Paste SpecialValuesOKEsc.

Right-click and "ungroup sheets"

Save as a new name.


Gord Dibben MS Excel MVP


On Sun, 28 Oct 2007 19:51:01 -0700, skysusan
wrote:

How to save the Excel file with the value only? The excel file is setup with
formula drawing from external data. Once data is drawn, need to save the copy
& distribute it.