I have some SharePoint connections inside of my Excel document. I exported all of the connections back out to SharePoint. The data connection orginaly was refrecing my C Drive and I wanted to connection to refrence SharePoint.
I found out that its still refrencing my C Drive and it also has the connection file on SharePoint. I can't figure out how to find the tables within Excel. I tried the Selection Pane but that only gave me images.
Below is the connections table that lists out all the tables if I wanted to connect to the workbook. I want to delete Main$list64597 and Manager Table$list63633. I just can't find it inside the workbook. Thank you for your help
<tbody>
</tbody>
I found out that its still refrencing my C Drive and it also has the connection file on SharePoint. I can't figure out how to find the tables within Excel. I tried the Selection Pane but that only gave me images.
Below is the connections table that lists out all the tables if I wanted to connect to the workbook. I want to delete Main$list64597 and Manager Table$list63633. I just can't find it inside the workbook. Thank you for your help
Select Table | ||||
Name | Description | Modified | Created | Type |
Groups$ | 6/27/2012 | 6/27/2012 | TABLE | |
Hours Logged$ | 6/27/2012 | 6/27/2012 | TABLE | |
Main$ | 6/27/2012 | 6/27/2012 | TABLE | |
Main$list64597 | 6/27/2012 | 6/27/2012 | TABLE | |
Manager Table$ | 6/27/2012 | 6/27/2012 | TABLE | |
Manager Table$list63633 | 6/27/2012 | 6/27/2012 | TABLE | |
Time PT$ | 6/27/2012 | 6/27/2012 | TABLE |
<tbody>
</tbody>