Bienvenue, Invité
Merci de vous identifier ou de vous inscrire.    Mot de passe perdu?

Excel keeps changing Links
(1 lecteur(s)) (1) Invité(s)
Aller en basPage: 1
SUJET: Excel keeps changing Links
#12498
jennermack
 
Messages: 21
Personne n'est hors ligne Cliquez ici pour consulter le profil de cet utilisateur
Excel keeps changing Links Il y a 1 Année, 6 Mois
Hi,

I've created a workbook that goes out and pulls data from another workbook to populate a sheet. Problem is that Excel seems to keep changing my hard-coded links into relative and I don't know how to stop it. Every Google search on the problem shows 99.9% returns for explaining how to create a link for newbies; so I figured I would ask here since I'm not finding much.
Created document here: "M:\_Financial\_CRPS\"
Linked to document to the other located here: "M:\_Financial\_CRPS\_Newest Exported\"
I created links to data with this formula:
='M:\_Financial\_CRPS\_Newest Exported\[FINAL EXPORT.xlsx]qry_CRPS Export'!E85
When I emailed the document, it changed my links to:
='C:\Users\rgillis\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\R5ATC0AG\_Newest Exported\[FINAL EXPORT.xlsx]qry_CRPS Export'!E85
Notice that it just decided that since the document was located in the path to the external source document that it could just convert my links to relative based upon it's network location. So what I did was take the document out of the M: drive, placed it on my desktop, Found and replaced all the links back to "='M:\_Financial\_CRPS\_Newest Exported", saved it, and copied it back to M drive. Now the links hold... except for the drive letter. When I email the document now it wants to look for ='C:\_Financial\_CRPS\_Newest Exported\[FINAL EXPORT.xlsx]qry_CRPS Export'!E85
Is there something I am missing to make this a Hard-coded link and not relative? Is there anyway to tell Excel to F' off I know what I am doing and I don't need your help maintaining my links?

Any help will be apprecited.

I didn't find the right solution from the Internet.

References:
arstechnica.com/civis/viewtopic.php?t=1143490
Animated Device Explainer Video

Thank you.
 
L'administrateur a désactivé l'accès public en écriture.
Revenir en hautPage: 1