Access Beginner
Active Member
- Joined
- Nov 8, 2010
- Messages
- 311
- Office Version
- 2016
- Platform
- Windows
Hi All,
Is there a way to directly connect PowerPivot to a SharePoint list? I've searched for a while now and can't seem to find a way. I have exported the SharePoint list to an excel file and I have connected the PowerPivot to that file, but it means refreshing that excel file and then the PowerPivot. Which is OK, but I'll need to connect 5 SharePoint lists and I'd like a direct connection. Any ideas?
Is there a way to directly connect PowerPivot to a SharePoint list? I've searched for a while now and can't seem to find a way. I have exported the SharePoint list to an excel file and I have connected the PowerPivot to that file, but it means refreshing that excel file and then the PowerPivot. Which is OK, but I'll need to connect 5 SharePoint lists and I'd like a direct connection. Any ideas?
