This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 77%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
I Have migrated 2010 production site to 2016 lab using DB Migraiton Method
so now 2016 lab has been given for testing.
Please help on how to solve below requirement from end user. Below is the query from end user who is testing 2016 lab site now.
FYI: post 2016 lab testing is done we will do migration to 2016 production.
Hi @sns
How do these files connect with the list? By Get date in excel?
If this is the case, when you need to reconnect to SharePoint 2016, you need to re-enter the new list url.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi Itch sun,
Please see below response from end user.
but not in 2016
user has created a reports using Create Excel Pivot Table and query list with excel
he wants that same report in 2016 as well. Please help.
Hi @sns
Through my test, this option is no longer available since SharePoint 2013.
This function is actually similar to treating the entire list as an excel sheet, opening the local excel, and creating a pivot table for this list.
Since this option no longer exists (because it is actually similar to the function of exporting to excel), I recommend that you export this list to excel, and then create a pivot chart in excel, etc.
If the user still wants to connect the excel file to the list, you can use the Excel Web Access web part.
