Editing Microsoft Excel (section)

=== Using other Windows applications ===
Windows applications such as [[Microsoft Access]] and Microsoft Word, as well as Excel can communicate with each other and use each other's capabilities. The most common is [[Dynamic Data Exchange]]: although strongly deprecated by Microsoft, this is a common method to send data between applications running on Windows, with official MS publications referring to it as "the protocol from hell".<ref name="Newcomer" /> As the name suggests, it allows applications to supply data to others for calculation and display. It is very common in financial markets, being used to connect to important financial data services such as [[Bloomberg L.P.|Bloomberg]] and [[Reuters]].

OLE Object Linking and Embedding allows a Windows application to control another to enable it to format or calculate data. This may take on the form of "embedding" where an application uses another to handle a task that it is more suited to, for example a [[PowerPoint]] presentation may be embedded in an Excel spreadsheet or vice versa.<ref name="Schmalz">{{cite book|title=Integrating Excel and Access|chapter=Chapter 5: Using Access VBA to automate Excel|author=Schmalz, Michael|chapter-url=https://books.google.com/books?id=SGH10fniqmsC&pg=PT71|isbn=978-0-596-00973-1|publisher=O'Reilly Media, Inc|year=2006}}{{cite book|title=Integrating Excel and Access|chapter=Chapter 5: Using Access VBA to automate Excel|author=Schmalz, Michael|chapter-url=https://books.google.com/books?id=SGH10fniqmsC&pg=PT71|isbn=978-0-596-00973-1|publisher=O'Reilly Media, Inc|year=2006}}</ref><ref name="Cornell">{{cite book|title=Excel as Your Database|author=Cornell, Paul|chapter=Chapter 5: Connect to other databases|page=[https://archive.org/details/excelasyourdatab0000corn/page/117 117 ''ff'']|chapter-url=https://books.google.com/books?id=qjkglmBy_l4C&pg=PA117|isbn=978-1-59059-751-4|year=2007|publisher=Apress|url=https://archive.org/details/excelasyourdatab0000corn/page/117}}</ref><ref name="DeMarco2">{{cite book|title=Pro Excel 2007 VBA|chapter=Excel's data import tools|page=43 ''ff''|chapter-url=https://books.google.com/books?id=gtPQMxO8XuoC&pg=PA43|publisher=Apress|author=DeMarco, Jim|isbn=978-1-59059-957-0|year=2008}}</ref><ref name="Harts">
{{cite book|title=Microsoft Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop|author=Harts, Doug|chapter-url=https://books.google.com/books?id=MVFldXVKpj8C&pg=PA171|year=2007|chapter=Importing Access data into Excel 2007|isbn=978-0-07-149424-3|publisher=McGraw-Hill Professional}}</ref>