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

--
Jim
"Arnis Celmins" <Arnis 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.
|