how to copy whole Excell workbook without links?

A

Arnis Celmins

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.
 
J

Jim Rech

Use the Edit, Links, Breaks Link feature. And save under another name.

--
Jim
|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.
|
 
D

Dave Peterson

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.
 
Top