save workbook with only values and no links

  • Thread starter Thread starter exeller
  • Start date Start date
E

exeller

I have a lot of workbooks which I have to handover to our accountant.
want to save them without the links to other workbooks.

I there a way to save a workbook without having to copy everything a
than paste it.

As it are workbooks linked with the add-in of exact globe, the value
won't appear when the connection to exact globe (accounting software
is not possible.

Thanks in advanc
 
Hi exceller,

I don't know what version it first appeared in, but if you go to Edit |
Links, you can click the Break Links button to break external links, which
accomplishes the same thing as copy / paste special values.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
And if your version of excel doesn't have the Edit|links|breaklinks, then maybe
you could do this:

Save your workbook as a new name--you don't want to ruin the original!

Rightclick on a worksheet tab
select All sheets
hit ctrl-A (to select all the cells) (ctrl-A twice with xl2003).
Edit|copy
Edit|paste special|Values
Select A1

Right click on a worksheet and select Ungroup Sheets

Save that workbook once more.
 
Back
Top