![]() ![]() It doesn't matter that I update data in the master file in local Onedrive or Excel online, I will have to keep the file opening, then open the department file in local Onedrive to update,īut If close both files, and reopen and update the department file in local Onedrive all the data will show #REF. In case of all the files are in the different Team sharepoint site. I cannot just click update like in 1.1 to make it works.Ģ. ![]() That's Ok.ġ.2 If I update data in the master file by Excel Online, I have to open the department file in local Onedrive, click update>edit link>update value to make it update. Then I open the department file in local Onedrive, click update then the data will be updated. ![]() In case of all the files are in the same Team sharepoint site.ġ.1 If I update data in the master file in local Onedrive and close it. Thank you for your help, but I found that is not practical at all.ġ. * Once complete conversation about this topic, kindly Mark and Vote any replies to benefit others reading this thread. Then opening the workbooks in Excel Online and refresh the page, the changes are also synced.Ĭliff * Beware of scammers posting fake support numbers here. In the A department workbook and B department workbook. Same ones in the same library in the same site or the different libraries in the different sites.Īfter you open the Master workbook and change the data from the OneDrive local sync folder, the update will be synced and showed If you use the OneDrive sync client and add the formulas in the opened workbooks, the formulas are the For B department referring to Column 1 and Column5, the formula is =Sheet1'!$A$2 and = Sheet1'!$E$2. For A department referring to Column1, Column2, Column3 and Column4, the formula is = Sheet1'!$A$2, = Sheet1'!$B$2, = Sheet1'!$C$2 and The local OneDrive sync folder and then add the reference formula in the workbooks. ![]() In the same library in the same site or the different libraries in the different sites, sync the files, open the files from The same library in the same site or the different libraries in the different sites as a workaround. To sync the workbooks and then open the workbooks from the local sync folder in The latest version of the OneDrive sync client As you are using a cell-to-cell reference feature (for example, I have a master workbook Master, A department workbook for A departmentĪnd B department workbook for B department.) and the link will be disabled when you open the file in Excel Online, you need to use ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |