<div>
that seemed to work, but when i make a change to the file on the sharepoint site, the formula on the local file is not updating with the new data.
</div>


that seemed to work, but when i make a change to the file on the sharepoint site, the formula on the local file is not updating with the new data.

<div>
I can't recall how I updated the links, vaguely recall having to have both files open which presumably defeats the object of what you're trying to achieve.
</div>


I can't recall how I updated the links, vaguely recall having to have both files open which presumably defeats the object of what you're trying to achieve.

<div>
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.<br />
<br />
I have recommended this question be closed as follows:<br />
<br />
Accept: Rob Henson (<a href="https:#a42249555" rel="ugc">https:#a42249555</a>)<br />
<br />
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.<br />
<br />
broomee9<br />
Experts-Exchange Cleanup Volunteer
</div>


No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Rob Henson (https:#a42249555 [https:#a42249555])

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

broomee9
Experts-Exchange Cleanup Volunteer

<div>
<div class="content wysiwyg-content">
I have an excel file in which i would like to connect it to an excel file that is saved in our sharepoint document library. &nbsp;I would like to be able to either pull all the data from the excel file in Sharepoint into my local excel file, or just create some formulas on my local excel file that will pull data from the sharepoint file.
</div>
</div>


I have an excel file in which i would like to connect it to an excel file that is saved in our sharepoint document library.  I would like to be able to either pull all the data from the excel file in Sharepoint into my local excel file, or just create some formulas on my local excel file that will pull data from the sharepoint file.

Excel 2016 - Connect to Excel file in Sharepoint library

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.