Links between workbooks in excel 2007
 

We develop excel documents that has several workbooks that have links between
them. During the development by one team, the links are developed between
different workbooks. When we send to eitors, they frequently change the
order of some rows and some liked spreadsheet loose data or have other
problems.

Is there a way to save the entire document as values instead of the links
when the first team gets done?

Thanks.

Links between workbooks in excel 2007
 

Right click oj tab name - select all sheets, highlight the greyed out cell
just above and to the left of cell A1, right click, copy, then paste as
special values only


Jim wrote:
We develop excel documents that has several workbooks that have links between
them. During the development by one team, the links are developed between
different workbooks. When we send to eitors, they frequently change the
order of some rows and some liked spreadsheet loose data or have other
problems.

Is there a way to save the entire document as values instead of the links
when the first team gets done?

Thanks.

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200911/1