Bluemoonrising
New Member
- Joined
- Nov 20, 2014
- Messages
- 1
Hi All,
Newbee PowerPivot user & I'm sure there must be a solution my problem!!
I have a spreadsheet with 6 powerpivot tables each on a separate tab - each powerpivot with multiple slicers. The underlying data model is updated via a linked excel table. The model is working perfectly with no issues. I render the spreadsheet via SharePoint & everything is perfect - until the spreadsheet is too large for SharePoint. The spreadsheet contains the linked table data which is generated from lookups against other external spreadsheets (I know that I could pull these into PowerPivot data model but that's a project for another day!). I thought that I could move the tab containing the table to a new spreadsheet & the linked table would automatically update but it doesn't! I don't want to completely rebuild the model for the sake of repointing a linked table to a new location. Is there a way to update the linked table reference?
Thanks!
Newbee PowerPivot user & I'm sure there must be a solution my problem!!
I have a spreadsheet with 6 powerpivot tables each on a separate tab - each powerpivot with multiple slicers. The underlying data model is updated via a linked excel table. The model is working perfectly with no issues. I render the spreadsheet via SharePoint & everything is perfect - until the spreadsheet is too large for SharePoint. The spreadsheet contains the linked table data which is generated from lookups against other external spreadsheets (I know that I could pull these into PowerPivot data model but that's a project for another day!). I thought that I could move the tab containing the table to a new spreadsheet & the linked table would automatically update but it doesn't! I don't want to completely rebuild the model for the sake of repointing a linked table to a new location. Is there a way to update the linked table reference?
Thanks!