Tool to auto fix broken excel links after migration to SharePoint online
Hi everyone, We are migrating one of our customer's file share the SharePoint online, and we getting big pushback from their finance department, as they have a lot of linked excel files. file link is broken after we test file move. We know we could change the link to URL. However, it is very hard to go through and change all the link and not impact the end users. Just wondering if anyone has similar experience before to share how you overcome this issue. also if you know any good tool can help to auto-fix the broken links. Thanks :)
Loading an Excel-worksheet from within SharePoint Online including auto-refresh
Hi, My use case is pretty easy I think. I am however unable to fully pull it of. Here's the setup: I have 1 big Excel-workbook that contains a lot of HR-data. This workbook will be refreshing daily and is stored in a simple documentlibrary on a SharePoint-site. I would like to have another Excel-workbook (or multiple) that use this first Excel-workbook as a datasource (via the Data-tab > New Query > From File > From Workbook > SharePoint-url for the workbook supplied, previously known as PowerQuery) to grab a subset of data. Why separate? So I can assign different permissions to each child-workbook on SharePoint. Display the workbooks from 2) on several SharePoint (modern) pages via the (new) Document-webpart. Everything above works in my environment, except 1 thing: I'd also like the workbooks from 2) auto-refresh when people visit the pages from 3). I've configured the datasource connection with the following: Auto-refresh when opening the file Datasource connects via current Windows-user credentials (we use ADFS, so this shouldn't be a problem I guess?) However: when I visit a page from 3), I'm greeted with a popup asking me to refresh the datasource, followed by another one stating "One or more dataconnections can't be refreshed"?