Home

Uploading Excel Workbooks that link to other Excel Workbooks?

%3CLINGO-SUB%20id%3D%22lingo-sub-286688%22%20slang%3D%22en-US%22%3EUploading%20Excel%20Workbooks%20that%20link%20to%20other%20Excel%20Workbooks%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-286688%22%20slang%3D%22en-US%22%3E%3CP%3EHowdy%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20moving%20some%20of%20our%20local%20file%20shares%20up%20into%20Teams.%26nbsp%3B%20Our%20accounting%20department%20has%20some%20Excel%20workbooks%20that%20link%20to%20other%20Excel%20workbooks%20to%20pull%20data.%26nbsp%3B%20After%20uploading%20the%20files%20to%20Teams%2C%20those%20workbooks%20don't%20seem%20to%20be%20working%20properly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20links%20inside%20the%20workbooks%20seems%20to%20have%20automatically%20updated%20the%20link%20as%20it%20now%20references%20a%20sharepoint%20URL%2C%20but%20the%20data%20in%20the%20main%20book%20doesn't%20seem%20to%20be%20updating%20properly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe've%20also%20tried%20syncing%20the%20files%20locally%20via%20the%20OneDrive%20client%20but%20that%20also%20didn't%20seem%20to%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20if%20this%20should%20work%20or%20not%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-286688%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-286785%22%20slang%3D%22en-US%22%3ERe%3A%20Uploading%20Excel%20Workbooks%20that%20link%20to%20other%20Excel%20Workbooks%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-286785%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20link%20two%20workbooks%20via%20Excel%20Online%3F%26nbsp%3B%20I%20could%20try%20resetting%20the%20links%20but%20don't%20know%20where%20that%20option%20is%20in%20Excel%20Online.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-286724%22%20slang%3D%22en-US%22%3ERe%3A%20Uploading%20Excel%20Workbooks%20that%20link%20to%20other%20Excel%20Workbooks%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-286724%22%20slang%3D%22en-US%22%3EMmm...what%20sounds%20strange%20to%20me%20is%20what%20you%20mention%20that%20the%20links%20has%20been%20updated.%20AFAIK%2C%20if%20you%20want%20your%20linked%20Excel%20to%20work%20when%20uploading%20to%20SPO%20%2F%20ODFB%2C%20you%20have%20to%20manually%20update%20the%20links...but%20I%20might%20be%20wrong%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776970%22%20slang%3D%22en-US%22%3ERe%3A%20Uploading%20Excel%20Workbooks%20that%20link%20to%20other%20Excel%20Workbooks%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776970%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F47110%22%20target%3D%22_blank%22%3E%40Mike%20Boehm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20Hi%26nbsp%3BMike%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BI%20have%20met%20the%20same%20issue%20when%20I%20use%20'Vlookup'%20to%20automatch%20the%20information%20from%20other%20excel%20file%20in%20the%20teams.%20It%20will%20have%20a%20long%20time%20delay.%20May%20I%20ask%20you%20how%20you%20solved%20it%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1092215%22%20slang%3D%22en-US%22%3ERe%3A%20Uploading%20Excel%20Workbooks%20that%20link%20to%20other%20Excel%20Workbooks%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1092215%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383546%22%20target%3D%22_blank%22%3E%40Hongkai%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20have%20you%20find%20a%20sollution%20to%20let%20the%20Vlookups%20work%3F%20At%20my%20workplace%20there%20is%20also%20a%20need%20for%20this%20(with%20Excel%20online%20%26amp%3B%20Teams).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20response!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1093475%22%20slang%3D%22en-US%22%3ERe%3A%20Uploading%20Excel%20Workbooks%20that%20link%20to%20other%20Excel%20Workbooks%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1093475%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F229655%22%20target%3D%22_blank%22%3E%40Viktoria%20Korman%3C%2FA%3E%26nbsp%3BHi%20Viktoria%2C%20I%20have%20not%20solve%20this%20issue.%20I%20finally%20choose%20to%20update%20the%20data%20in%20the%20local%20and%20upload%20the%20updated%20file%20into%20Teams!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1094116%22%20slang%3D%22en-US%22%3ERe%3A%20Uploading%20Excel%20Workbooks%20that%20link%20to%20other%20Excel%20Workbooks%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1094116%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383546%22%20target%3D%22_blank%22%3E%40Hongkai%3C%2FA%3E%26nbsp%3Bthank%20you%20for%20your%20fast%20reply!%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20is%20also%20what%20we%20are%20doing.%26nbsp%3B%3C%2FP%3E%3CP%3EGoodluck!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Regular Contributor

Howdy,

 

We are moving some of our local file shares up into Teams.  Our accounting department has some Excel workbooks that link to other Excel workbooks to pull data.  After uploading the files to Teams, those workbooks don't seem to be working properly.

 

The links inside the workbooks seems to have automatically updated the link as it now references a sharepoint URL, but the data in the main book doesn't seem to be updating properly.

 

We've also tried syncing the files locally via the OneDrive client but that also didn't seem to help.

 

Does anyone know if this should work or not?

 

Thanks

6 Replies
Highlighted
Mmm...what sounds strange to me is what you mention that the links has been updated. AFAIK, if you want your linked Excel to work when uploading to SPO / ODFB, you have to manually update the links...but I might be wrong
Highlighted

How do I link two workbooks via Excel Online?  I could try resetting the links but don't know where that option is in Excel Online.

Highlighted

@Mike Boehm 

  Hi Mike,

       I have met the same issue when I use 'Vlookup' to automatch the information from other excel file in the teams. It will have a long time delay. May I ask you how you solved it? Thanks!

Highlighted

@Hongkai 

Hi, have you find a sollution to let the Vlookups work? At my workplace there is also a need for this (with Excel online & Teams). 

 

Thank you for your response! 

Highlighted

@Viktoria Korman Hi Viktoria, I have not solve this issue. I finally choose to update the data in the local and upload the updated file into Teams! 

Highlighted

@Hongkai thank you for your fast reply! 

That is also what we are doing. 

Goodluck! 

Related Conversations
VLOOKUP function help
Adithya_K in Excel on
5 Replies
Return value Y/N if text is within a cell.
lucas_h in Excel on
5 Replies
Giving value based on cell color
RubyBlade888 in Excel on
1 Replies