software

I have a workbook with multiple worksheets. Values are gathered via links,
which may not be accesible all the time. Therefore, I am thinking of easy way
to copy the whole workbook without links, just like with the function Paste
Special/values.Use the Edit, Links, Breaks Link feature. And save under another name.

--
Jim
quot;Arnis Celminsquot; lt;Arnis gt; wrote in message
...
|I have a workbook with multiple worksheets. Values are gathered via links,
| which may not be accesible all the time. Therefore, I am thinking of easy
way
| to copy the whole workbook without links, just like with the function
Paste
| Special/values.
|
Save your workbook as a new name first--just in case!!!

Select all the worksheets that have to all the formulas converted to values.
(Click on the first tab and ctrl-click (or shift click) on more tabs)

Select all the cells in the active sheet
edit|copy
edit|paste special|values

select A1

Ungroup the worksheets

And check it out.

Arnis Celmins wrote:
gt;
gt; I have a workbook with multiple worksheets. Values are gathered via links,
gt; which may not be accesible all the time. Therefore, I am thinking of easy way
gt; to copy the whole workbook without links, just like with the function Paste
gt; Special/values.

--

Dave Peterson

My response converts all formulas to values--not just the formulas with links.

If your version of excel doesn't allow you to use Jim's suggestion...

When I can't find links, I'll use Bill Manville's FindLink program:
www.oaltd.co.uk/MVP/Default.htm
Dave Peterson wrote:
gt;
gt; Save your workbook as a new name first--just in case!!!
gt;
gt; Select all the worksheets that have to all the formulas converted to values.
gt; (Click on the first tab and ctrl-click (or shift click) on more tabs)
gt;
gt; Select all the cells in the active sheet
gt; edit|copy
gt; edit|paste special|values
gt;
gt; select A1
gt;
gt; Ungroup the worksheets
gt;
gt; And check it out.
gt;
gt; Arnis Celmins wrote:
gt; gt;
gt; gt; I have a workbook with multiple worksheets. Values are gathered via links,
gt; gt; which may not be accesible all the time. Therefore, I am thinking of easy way
gt; gt; to copy the whole workbook without links, just like with the function Paste
gt; gt; Special/values.
gt;
gt; --
gt;
gt; Dave Peterson

--

Dave Peterson