View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default how to copy whole Excell workbook without links?

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:
http://www.oaltd.co.uk/MVP/Default.htm



Dave Peterson wrote:

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:

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.


--

Dave Peterson


--

Dave Peterson