![]() ![]() My assumption this is done to ensure I can update values wherever I am accessing the files (ie on Excel Online), however if the values do not update this is time consuming, as often the spreadsheets i work on could have 5 or 6 different pages with externalįile references sometimes 100 or so cells on each. Then when I close the files and reopen the references revert to the “ and fail to update again. I do this using find and replace on whole spreadsheet and all the values update as expected. To force the values to update i have to remove the “ element of formula so i am left with “=A1]” for example. ![]() ![]() If i open the files in question from my OneDrive sync folders (as i would do in the past) the value still doesn’t update. When I open an excel file that references another file i get an error stating that values cannot be updated. Click Kutools Plus > Workbook > Insert Workbook Information.See screenshot: 2. With the Insert Workbook Information utility of Kutools for Excel, you can easily reference the sheet tab name in any cell you want.Please do as follows. My SharePoint Folders and Files sync to my mac using OneDrive. Reference the current sheet tab name in cell with Kutools for Excel. I have been using Excel for many years and have a couple of spreadsheets that are failing to update values held in other spreadsheets on OneDrive/Sharepoint.įirst off best to explain how i access and store files.Īll working files are stored on Sharepoint
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |