External reference changing the link

5

50pingviner

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?.. I still have access
to the files on the network.

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

I hope somebody can help me here.

Thx. Lars
 
5

50pingviner

That wont help for two reasons:

1. It is not possible to edit the links in the cells because th
contain formulas so long, that excel cant change the link sources...i
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 tim
to change links on every network sheet i open during the days as ther
are many links and I work in a lot of different network sheets.

But thanks for the reply
 
Top