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?Post a Teams message, when Excel online criteria is met.
Hi, The idea/problem I would like to solve is to post a message everyday if a criteria is met. Th Excel online Sheet Column "Bursdag i dag" (Birthday today) is set to yes ithe person have birthday. The flow: Scheduled to run everyday Check if the column is "ja" Post a message at Teams: I Guess the way I check column value in Excel is wrong here. Is this scenario possible? If yes, how do I configure it? Best Regards - GeirUsers 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?
