Hi,

I have a worksheet full of external references to other worksheets on
network drives.

I have recently updated to excel 2003 and now when I open the workbook,
the links point to somewhere on my harddrive (c-drive).

How do I get the sheet to point to the network when I open the
workbook?.. I still have access to the files on the network.

It changes the links on old as well as new files.. any time I set up an
external reference, it changes it next time I open the workbook.

I have previously used synchronization on my files, which might affect
the links, as they are copied down on my hard drive, but now I have
switched of synchronization and it still changes the links on new
files.

The consequence is that I cant work in the files, because if I save
them, I completely mess up the links for everybody else.

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 I dont want to edit the links 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.

I hope someone can help me.

~Lars


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