TCD data import from SharePoint Online
madmyke Posted messages 52304 Registration date Status Moderator Last intervention -
Hello, I have a SharePoint Online storage space on my institution's tenant,
before being on SPO, we could import data to create a PivotTable from a third-party Excel file via "Get Data" -> "From File" -> "From Excel Workbook".
The problem now is that with OneDrive synchronization from SharePoint, when I do this operation, it takes into account the file path relative to OneDrive for importing the values (e.g.: C:\Users\me\mytenant\mytenant documents\mysourceexcel.xlsx)
However, if another person tries to open the data file containing the PivotTable:
(e.g.: C:\Users\me\mytenant\mytenant documents\myTCDexcel.xlsx) it indicates that it cannot find the file path of "Me".
How can I make it look for the data in web only?
Thank you in advance for your responses
1 answer
Hello
It's not really my area because we use these functions very little, but since no one is responding...
Obviously, given the path, no one else will be able to work on it since it's local.
From what I know, in order for it to be accessible to others, it first needs to be shared and designate either one or several users, or a group.
Since SharePoint and Drive are quite specific things where a SharePoint admin can (or cannot) decide to enable certain features, as well as the default configuration on the PCs of an entity may contain specific GPOs, in principle, we turn to the manager or the IT service for this type of problem/question.
It's the same with Teams; we can use it perfectly well but with restrictions that don't exist "elsewhere", which are blocked at the level of the company/entity, for various reasons. (Security, cost, etc).
Best regards