| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
External reference changing the link
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 -- 50pingviner ------------------------------------------------------------------------ 50pingviner's Profile: http://www.excelforum.com/member.php...o&userid=29298 View this thread: http://www.excelforum.com/showthread...hreadid=490139 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
External reference changing the link
From the Menu choose Edit / Links
"50pingviner" wrote: 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 -- 50pingviner ------------------------------------------------------------------------ 50pingviner's Profile: http://www.excelforum.com/member.php...o&userid=29298 View this thread: http://www.excelforum.com/showthread...hreadid=490139 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
External reference changing the link
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change reference to other worksheet by changing one cell? | Excel Worksheet Functions | |||
| Error "Unable to save external link values" | Excel Discussion (Misc queries) | |||
| Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
| changing the formula's row reference | Excel Discussion (Misc queries) | |||
| changing multiple cells from relative to absolute reference | Excel Discussion (Misc queries) | |||
Hybrid Mode
