software

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:
gt; Hi,
gt;
gt; I have an excel file with about 40 worksheets containing a lot of links and
gt; formulas. I want to create a copy of this file showing just the values (no
gt; formula and links). Is there any way to copy the whole file as value.
gt; Please send your reply to me at or .
gt;
gt; Thanks a lot.
gt;
gt; Shahbaz.shahbaz wrote:
gt; Hi,
gt;
gt; I have an excel file with about 40 worksheets containing a lot of links and
gt; formulas. I want to create a copy of this file showing just the values (no
gt; formula and links). Is there any way to copy the whole file as value.
gt; Please send your reply to me at or .
gt;
gt; Thanks a lot.
gt;
gt; Shahbaz.

Select what you want to copy. Then right click to select quot;paste
specialquot; and select quot;valuesquot; 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.

quot; wrote:

gt; shahbaz wrote:
gt; gt; Hi,
gt; gt;
gt; gt; I have an excel file with about 40 worksheets containing a lot of links and
gt; gt; formulas. I want to create a copy of this file showing just the values (no
gt; gt; formula and links). Is there any way to copy the whole file as value.
gt; gt; Please send your reply to me at or .
gt; gt;
gt; gt; Thanks a lot.
gt; gt;
gt; gt; Shahbaz.
gt;
gt; Select what you want to copy. Then right click to select quot;paste
gt; specialquot; and select quot;valuesquot; only to obtain the values without the
gt; formulars and links.
gt;
gt;

Right-click on a sheet tab and quot;select all sheetsquot;.

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

Copy. Paste Special(in place)gt;Valuesgt;OKgt;Esc.

Ungroup the sheets by selecting any non-active sheet.

Filegt;Save As and give it a name or just Filegt;Save if you wish to overwrite the
original.Gord Dibben MS Excel MVPOn Fri, 20 Jan 2006 07:48:05 -0800, quot;shahbazquot;
gt; wrote:

gt;I know that I can do this some selection or for the whole worksheet but I
gt;want to know is there any way to do this in just few cliks.
gt;
gt;Shahbaz.
gt;
quot; wrote:
gt;
gt;gt; shahbaz wrote:
gt;gt; gt; Hi,
gt;gt; gt;
gt;gt; gt; I have an excel file with about 40 worksheets containing a lot of links and
gt;gt; gt; formulas. I want to create a copy of this file showing just the values (no
gt;gt; gt; formula and links). Is there any way to copy the whole file as value.
gt;gt; gt; Please send your reply to me at or .
gt;gt; gt;
gt;gt; gt; Thanks a lot.
gt;gt; gt;
gt;gt; gt; Shahbaz.
gt;gt;
gt;gt; Select what you want to copy. Then right click to select quot;paste
gt;gt; specialquot; and select quot;valuesquot; only to obtain the values without the
gt;gt; formulars and links.
gt;gt;
gt;gt;