Sharing data between excel tables in SharePoint
Hi All, This might have been answered somewhere else but can't find the answer. I am trying to link data between Excel tables in SharePoint. Basically, I have multiple workbooks where I use a VLOOKUP formula to pull data from the other workbook. Problem is it only works when all workbooks are open (e.g. the workbook that has the information in originally). I thought with it being on SharePoint it would pull the information automatically without the need to keep the workbooks open. I even thought it would work on Excel online, but no luck. Can anyone help?Users seeing different document version
Hi, I have two users who regularly access an excel spreadsheet in the browser, usually at the same time. They have noticed that they often see different versions of the spreadsheet, for example user1 sees the version that he edited the previous day and user2 sees a version where those edits are not showing. We have a workaround in place where they can check through the version history and restore the version that needs to be in place. Also, the correct version apppeared for both users after about 24 hours without any action being taken. Has anyone experienced the same issues?
