Home

Excel Breaking Links between sheets/workbooks

%3CLINGO-SUB%20id%3D%22lingo-sub-650483%22%20slang%3D%22en-US%22%3EExcel%20Breaking%20Links%20between%20sheets%2Fworkbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-650483%22%20slang%3D%22en-US%22%3EHi%20all%2C%20I%20have%20asked%20this%20question%20on%20a%20couple%20other%20forums%20and%20haven't%20really%20got%20much%20of%20a%20reply%2Fsolutions.%20I'm%20hoping%20some%20of%20you%20may%20be%20able%20to%20shed%20some%20light%20on%20things%3A%3CBR%20%2F%3E%3CBR%20%2F%3EI%20use%20Excel%20for%20work%20and%20we%20recently%20moved%20over%20to%20OneDrive%20for%20business%20and%20SharePoint.%20The%20Onedrive%20is%20mapped%20as%20a%20drive%20and%20I%20only%20use%20Excel%20as%20a%20local%20app%2C%20i.e%20No%20Excel%20online.%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20I%20create%20a%20link%20between%202%20sheets%20in%20separate%20workbooks%20they%20break%20after%20saving.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20a%20work%20around%20for%20this%3F%20It%20seems%20like%20there%20is%20a%20problem%20with%20it.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you.%3CBR%20%2F%3E%3CBR%20%2F%3EExtra%20info%3A%3CBR%20%2F%3E%3CBR%20%2F%3EHere%20is%20the%20original%20path%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3D'%5BNEW!%20Crew%20Utilization%20Hours%20(2019).xlsm%5DChart%20Info'!%24C%24114%3CBR%20%2F%3E%3CBR%20%2F%3Eand%20here%20is%20the%20path%20after%20saving%20the%20file%20and%20re-openning%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3D'https%3A%2F%2F******.sharepoint.com%2FUsers%2F*****%2F******%2F********%20-%20*******%2F%5BNEW!%20Crew%20Utilization%20Hours%20(2019).xlsm%5DChart%20Info'!%24C%24114%3CBR%20%2F%3E%3CBR%20%2F%3E(note%20the%20***%20are%20removed%20possible%20sensitive%20information)%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20path%20restructures%20itself%2C%20not%20in%20it's%20self%20an%20issue%20for%20me....if%20it%20worked!%20That's%20the%20problem%2C%20whenever%20I%20re-open%20after%20saving%20the%20links%20no%20longer%20update%20etc%20etc%20and%20Excel%20fires%20warnings%20off%20at%20me%20to%20that%20point.%3CBR%20%2F%3E%3CBR%20%2F%3EAlso%20this%20is%20Excel%202016%20that%20I%20am%20working%20with.%3CBR%20%2F%3E%3CBR%20%2F%3EUPDATE%3A%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20been%20playing%20around%20with%202%20seperate%20workbook%20test%20files%2C%20contained%20in%20seperate%20folders%20on%20the%20same%20OneDrive.%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20the%20test%20files%20I%20have%20noticed%20that%20the%20problem%20does%20not%20happen%20when%20a%20different%20'Path'%20is%20used%20for%20example%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3DSERIES(%2C'https%3A%2F%2F****.sharepoint.com%2Fsites%2F*********%2FShared%20Documents%2F******%2FMANAGER%2FTest%201%2F%5BTest%201.xlsx%5DSheet1'!%24A%243%3A%24C%243%2C'https%3A%2F%2F*****.sharepoint.com%2Fsites%2F*****%2FShared%20Documents%2F******%2FMANAGER%2FTest%201%2F%5BTest%201.xlsx%5DSheet1'!%24A%246%3A%24C%246%2C3)%3CBR%20%2F%3E%3CBR%20%2F%3EThat%20path%20works!%20no%20errors%20and%20no%20cant%20update.%3CBR%20%2F%3E%3CBR%20%2F%3EHowever%20I%20don't%20seem%20to%20have%20any%20control%20over%20how%20that%20path%20is%20created%20as%20opposed%20to%20the%20other%20non%20working%20path%2C%20sometimes%20the%20first%20path%20is%20created%20by%20excel%20and%20sometimes%20it%20is%20this%20type%20created%20which%20works%2C%20or%20is%20it%20something%20I%20am%20unwittingly%20doing%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-650483%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
J4C3N14
Regular Visitor
Hi all, I have asked this question on a couple other forums and haven't really got much of a reply/solutions. I'm hoping some of you may be able to shed some light on things:

I use Excel for work and we recently moved over to OneDrive for business and SharePoint. The Onedrive is mapped as a drive and I only use Excel as a local app, i.e No Excel online.

When I create a link between 2 sheets in separate workbooks they break after saving.

Is there a work around for this? It seems like there is a problem with it.

Thank you.

Extra info:

Here is the original path:

='[NEW! Crew Utilization Hours (2019).xlsm]Chart Info'!$C$114

and here is the path after saving the file and re-openning:

='https://******.sharepoint.com/Users/*****/******/******** - *******/[NEW! Crew Utilization Hours (2019).xlsm]Chart Info'!$C$114

(note the *** are removed possible sensitive information)

The path restructures itself, not in it's self an issue for me....if it worked! That's the problem, whenever I re-open after saving the links no longer update etc etc and Excel fires warnings off at me to that point.

Also this is Excel 2016 that I am working with.

UPDATE:

I have been playing around with 2 seperate workbook test files, contained in seperate folders on the same OneDrive.

In the test files I have noticed that the problem does not happen when a different 'Path' is used for example:

=SERIES(,'https://****.sharepoint.com/sites/*********/Shared Documents/******/MANAGER/Test 1/[Test 1.xlsx]Sheet1'!$A$3:$C$3,'https://*****.sharepoint.com/sites/*****/Shared Documents/******/MANAGER/Test 1/[Test 1.xlsx]Sheet1'!$A$6:$C$6,3)

That path works! no errors and no cant update.

However I don't seem to have any control over how that path is created as opposed to the other non working path, sometimes the first path is created by excel and sometimes it is this type created which works, or is it something I am unwittingly doing?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies