Hi,

I have one workbook containing hundreds of sheets and a huge amount of
formulas.
Is there a way to create a a macro that copy all the values, (no formulas,
no formatting), to a new workbook which are identical to the first one?
This is necessary as I sometimes need to "update" my workbook, whitout
losing all of my manually printed values.
Also there are links to this workbook to other workbooks, therefore it needs
to be renamed to the same name as the old woorkbooks name, to get the links
working as before.

Regards,

Thomas