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 :)
Data Query from a parent SharePoint Online Site
Hi, I'm trying to get data into an Excel worksheet from a list in SharePoint Online. I'm doing so through Data tab --> New Query --> From Other Sources --> From SharePoint List At the beginning, I tried this on a testing subsite within my SharePoint https://mysite.sharepoint.com/testsite and it worked. It returned all the available lists in that subsite and I was able to fetch them into Excel. However, then I created the actual list that I want to import in the main site, which is just https://mysite.sharepoint.com but it always gives an error: DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. Details: DataSourceKind=SharePoint DataSourcePath=https://mysite.sharepoint.com/_vti_bin/ListData.svc (basically means it can't find any lists) I've attached a screenshot of the error So does import data from SharePoint list just works for the subsites?
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"?