SOLVED

Manejo de un vinculos en Excel 365

%3CLINGO-SUB%20id%3D%22lingo-sub-1631387%22%20slang%3D%22es-ES%22%3EHandling%20a%20Link%20in%20Excel%20365%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1631387%22%20slang%3D%22es-ES%22%3E%3CP%3EGood!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20a%20problem%20and%20we%20didn't%20find%20the%20solution.%20A%20company%20department%20works%20with%20a%20set%20of%20Excels%20that%20link%20to%20each%20other%2C%20using%20intertcrossed%20information%20from%20all%20these%20files%20in%20its%20co-founded%20information.%20They%20worked%20each%20on%20their%20PC%3B%20and%20links%20between%20Excels%20use%20network%20shared%20folders.%20In%20addition%2C%20several%20people%20work%20on%20the%20same%20file.%20Having%20standard%20link%20paths%20(network%20folders)%20everything%20works%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20that%20we%20migrated%20to%20Office%20365%20and%20we%20don't%20know%20how%20to%20accomplish%20this.%20They%20have%20OneDrive%20installed%2C%20but%20the%20links%20were%20modified%20as%20an%20access%20URL%2C%20which%20do%20not%20always%20work%2C%20or%20are%20automatically%20changed%20to%20the%20local%20folder%3B%20therefore%20when%20someone%20else%20wants%20to%20access%20the%20file%2C%20however%20shared%2C%20all%20links%20are%20broken.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%2C%20on%20how%20to%20work%20with%20links%20about%20Sharepoint%2FOneDrive%20and%20get%20a%20team%20to%20access%20the%20files%20while%20retaining%20the%20links%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1631387%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

Buenas!!!

 

Tenemos un problema y no dimos con la solución. Un departamento de la empresa, trabaja con un conjunto de Excels que se vinculan entre sí, utilizando en sus celadas información entrecruzada de todos estos archivos. Ellos trabajaban cada uno en su PC; y los vínculos entre los Excel utilizan carpetas compartidas de red. Asimismo, varias personas trabajan sobre un mismo archivo. Al tener paths de vinculos estándares (carpetas de red) todo funciona bien.

 

El problema es que migramos a Office 365 y no sabemos como lograr esto. Tienen instalado Onedrive, pero los vínculos se modificaron como una URL de acceso, que no siempre funcionan, o se cambian automáticamente a la carpeta local; por lo tanto cuando otra persona quiere acceder al archivo, por más que esté compartido, todos los vínculos se rompen.

 

Alguna sugerencia, sobre como trabajar con vínculos sobre Sharepoint / Onedrive y lograr que un equipo de trabajo acceda a los archivos conservando los vínculos?

 

Muchas gracias.

1 Reply
Highlighted
Best Response confirmed by JGambino (Occasional Visitor)