Hi,

I have an excel file with about 40 worksheets containing a lot of links and
formulas. I want to create a copy of this file showing just the values (no
formula and links). Is there any way to copy the whole file as value.
Please send your reply to me at or .

Thanks a lot.

Shahbaz.

shahbaz wrote:
Hi,

I have an excel file with about 40 worksheets containing a lot of links and
formulas. I want to create a copy of this file showing just the values (no
formula and links). Is there any way to copy the whole file as value.
Please send your reply to me at or .

Thanks a lot.

Shahbaz.

shahbaz wrote:
Hi,

I have an excel file with about 40 worksheets containing a lot of links and
formulas. I want to create a copy of this file showing just the values (no
formula and links). Is there any way to copy the whole file as value.
Please send your reply to me at or .

Thanks a lot.

Shahbaz.

Select what you want to copy. Then right click to select "paste
special" and select "values" only to obtain the values without the
formulars and links.

I know that I can do this some selection or for the whole worksheet but I
want to know is there any way to do this in just few cliks.

Shahbaz.

" wrote:

shahbaz wrote:
Hi,

I have an excel file with about 40 worksheets containing a lot of links and
formulas. I want to create a copy of this file showing just the values (no
formula and links). Is there any way to copy the whole file as value.
Please send your reply to me at or .

Thanks a lot.

Shahbaz.

Select what you want to copy. Then right click to select "paste
special" and select "values" only to obtain the values without the
formulars and links.

Right-click on a sheet tab and "select all sheets".

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

Copy. Paste Special(in place)ValuesOKEsc.

Ungroup the sheets by selecting any non-active sheet.

FileSave As and give it a name or just FileSave if you wish to overwrite the
original.


Gord Dibben MS Excel MVP


On Fri, 20 Jan 2006 07:48:05 -0800, "shahbaz"
wrote:

I know that I can do this some selection or for the whole worksheet but I
want to know is there any way to do this in just few cliks.

Shahbaz.

" wrote:

shahbaz wrote:
Hi,

I have an excel file with about 40 worksheets containing a lot of links and
formulas. I want to create a copy of this file showing just the values (no
formula and links). Is there any way to copy the whole file as value.
Please send your reply to me at or .

Thanks a lot.

Shahbaz.

Select what you want to copy. Then right click to select "paste
special" and select "values" only to obtain the values without the
formulars and links.