SOLVED

Worksheet links changing

%3CLINGO-SUB%20id%3D%22lingo-sub-3216155%22%20slang%3D%22en-US%22%3EWorksheet%20links%20changing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3216155%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20workbook%20with%20about%2025%20worksheets.%20I%20store%20in%20in%20OneDrive%20and%20it%20automatically%20saves.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20try%20to%20set%20up%20an%20internal%20link%20between%20workbooks%20the%20link%20addresses%20keep%20changing%20to%20match%20the%20temporary%20file%20name%20that%20seems%20to%20be%20allocated%20when%20automatically%20saving.%26nbsp%3B%20For%20example%20if%20I%20want%20to%20link%20to%20Current_Account%20The%20link%20appears%20as%20%3CA%20href%3D%22https%3A%2F%2Fd.docs.live.net%2F3969e63a9043beds%2Fdesktop%2FPersonal%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fd.docs.live.net%2F3969e63a9043beds%2Fdesktop%2FPersonal%3C%2FA%3E%26nbsp%3B%20Accounts.xlsm%20-%20'Current_Account'!A4%20This%20works%20for%20that%20session%20then%20when%20I%20reopen%20the%20workbook%20it%20seems%20to%20have%20a%20different%20name%20and%20I%20get%20a%20message%20that%20the%20link%20is%20invalid.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20have%20an%20internal%20link%20that%20doesn't%26nbsp%3B%20reference%20the%20full%20file%20name%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3216155%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3216698%22%20slang%3D%22en-US%22%3ERe%3A%20Worksheet%20links%20changing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3216698%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1318459%22%20target%3D%22_blank%22%3E%40Alanagalashan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fstackoverflow.com%2Fquestions%2F33734706%2Fexcels-fullname-property-with-onedrive%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EExcel's%20fullname%20property%20with%20OneDrive%3C%2FA%3E%3C%2FP%3E%3CP%3EOneDrive%20%26gt%3B%20Settings%20%26gt%3B%20Office%3A%20-%20Uncheck%20'Use%20Office%20applications%20to%20sync%20Office%20files%20that%20I%20open'%3C%2FP%3E%3CP%3EThis%20lets%20excel%20save%20the%20file%20in%20the%20typical%20%22C%3A%5CUsers%5BUserName%5D%5COneDrive...%22%20file%20format%20instead%20of%20the%20UNC%20%22https%3A%5C%22%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20I%20was%20able%20to%20help%20you%20with%20this%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fmeet-niko-chatzoudis-excel-forum-contributor%2Fba-p%2F2941385%22%20target%3D%22_blank%22%3ENikolinoDE%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3217870%22%20slang%3D%22en-US%22%3ERe%3A%20Worksheet%20links%20changing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3217870%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40NikolinoDE%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20-%20that%20fixed%20my%20problem!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlan%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have an excel workbook with about 25 worksheets. I store in in OneDrive and it automatically saves.

 

When I try to set up an internal link between workbooks the link addresses keep changing to match the temporary file name that seems to be allocated when automatically saving.  For example if I want to link to Current_Account The link appears as https://d.docs.live.net/3969e63a9043beds/desktop/Personal  Accounts.xlsm - 'Current_Account'!A4 This works for that session then when I reopen the workbook it seems to have a different name and I get a message that the link is invalid.

 

Is it possible to have an internal link that doesn't  reference the full file name

3 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Alanagalashan 

Excel's fullname property with OneDrive

OneDrive > Settings > Office: - Uncheck 'Use Office applications to sync Office files that I open'

This lets excel save the file in the typical "C:\Users[UserName]\OneDrive..." file format instead of the UNC "https:\" format.

 

Hope I was able to help you with this info/link.

 

NikolinoDE

I know I don't know anything (Socrates)

@NikolinoDE  

 

Thanks - that fixed my problem!

 

Alan

I'm glad that I could help to solve your problem.

I wish you much success with Excel.