* Once complete conversation about this topic, kindly Mark and Vote any replies to benefit others reading this thread. Links between spreadsheets in Excel Online.Īppreciate your patience and understanding.Ĭhitrahaas - * Beware of scammers posting fake support numbers here. To be used in the future in Excel for web. But the good news is related developing Excel team stated that implementation of this feature is started even though there is no any ETA for this release, we can expect this feature We feel your pain due to this limitation and we’re really feel sorry for it. Even other users who’re having the access to Document library, can sync it and use the workbooks. After re-adding the links, you can check the location of data source in the destination files where it shows the path of SharePoint Online.ĭ. Now you need to break all the links and re-add the links again.Ĭ. uploaded to SharePoint Online Document library) and Destination file (that are already present in your SharePoint Online).ī.

You need to open the both Data Source (i.e. Note: I hope I summarized your scenario correctly.Īs this external links is not supported in Excel for web, other users need to sync the SharePoint Document library to their device and you need to follow the workaround to change the location of data source from c: drive to online path.įirstly, I apologize for this because it consumes little time of yours because as you already linked multiple Excel files.Ī.

But, opening the files that are linked will show the location locally instead of SharePoint Online location. So, after linking them as you want to make other members in SharePoint Document library to work with that files, you uploaded the data source files into same SharePoint Document library.Į. Since the External reference links are only for view only in Excel for Web, you used the Excel client to achieve it by syncing SharePoint Online Document library using OneDrive Sync client.ĭ. You want to link the multiple Excel files to files that are present in SharePoint Online.Ĭ. You’re having the files in SharePoint Online Document library.ī. Sorry for the trouble caused at your end and we do understand the problem you’re facing, but I would like to summarize your problem before providing workaround to your situation.Ī. Please could someone direct me to an explicit methodology to do this? Really hoping linked files comes to Excel online soon!Īnd thanks for whoever is able to direct a bumbling idiot through this one. These other users are aware they need to open in desktop Excel and not online to ensure

I 100% need the files to be looking at paths within Sharepoint so that when users are using the files on other machines etc, the linkages work and data falls through. Even if I upload to Sharepoint the links are still looking on my c: drive. The sync'd files on my local hard drive that are linked AND that the links refer to my sync'd hard drive copy also. As I need to link multiple Excel files, I am opening the files from OneDrive and linking using Excel desktop. I have files on Sharepoint from an organisation and am connecting via OneDrive on my macbook (don't ask).

I am very sure that this is my searching etc so apologies. Simply however they don't answer explicitly what I want to do, or I cannot find a 100% answer. Apologies as I feel somewhat defeated posting this as there are a tonne of other posts.

Linking sharepoint to onedrive on a mac