| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to fix a link in excel
The links in Excel are not fixed but variable:
upon creation of the file and link, the link in the destination file cell a1 is ='h:\[template.xls]Source'!a1 however, when the destination file is moved, the link sometimes changes. As the destination file is sent over the world to other people and returned after updating some information (not the cell with the link, that is protected), the destination file returns with a changed link (in the protected field). I do not know what other people do but I would like to prevent the change in link. Does anyone have an idea? Thx -- Thx |
|
#2
|
|||
|
|||
|
if you use the indirect function the link will not change
=indirect("'h:\[template.xls]Source'!a1") "Incognito" wrote: The links in Excel are not fixed but variable: upon creation of the file and link, the link in the destination file cell a1 is ='h:\[template.xls]Source'!a1 however, when the destination file is moved, the link sometimes changes. As the destination file is sent over the world to other people and returned after updating some information (not the cell with the link, that is protected), the destination file returns with a changed link (in the protected field). I do not know what other people do but I would like to prevent the change in link. Does anyone have an idea? Thx -- Thx |
|
#3
|
|||
|
|||
|
BJ,
Super! This will save a lot of extra workload. THX -- Thx "bj" wrote: if you use the indirect function the link will not change =indirect("'h:\[template.xls]Source'!a1") "Incognito" wrote: The links in Excel are not fixed but variable: upon creation of the file and link, the link in the destination file cell a1 is ='h:\[template.xls]Source'!a1 however, when the destination file is moved, the link sometimes changes. As the destination file is sent over the world to other people and returned after updating some information (not the cell with the link, that is protected), the destination file returns with a changed link (in the protected field). I do not know what other people do but I would like to prevent the change in link. Does anyone have an idea? Thx -- Thx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop e-mail address from turning into link in Excel? | Excel Discussion (Misc queries) | |||
| How to link a document to a workbook with a hyperlink in excel | Excel Worksheet Functions | |||
| How do I link to an Outlook public folder from an Excel spreadshe. | Excel Discussion (Misc queries) | |||
| most effective way to link ms word tables to excel | Excel Discussion (Misc queries) | |||
| Open a file in excel from a link in eplorer | Excel Discussion (Misc queries) | |||
Linear Mode
