That wont help for two reasons:

1. It is not possible to edit the links in the cells because the
contain formulas so long, that excel cant change the link sources...it
says "cant change link, the formula is too long".

But more importantly:

2. Because it does it every time I open the sheet and I dont have time
to change links on every network sheet i open during the days as there
are many links and I work in a lot of different network sheets.

But thanks for the reply.


--
50pingviner
------------------------------------------------------------------------
50pingviner's Profile: http://www.excelforum.com/member.php...o&userid=29298
View this thread: http://www.excelforum.com/showthread...hreadid=490139