Excel and PowerPoint are often used in conjunction with one another to produce financial reports, audit reports, due diligence reports, pitchbooks, investment memorandum, portfolio reviews, and more. Show
When it comes to budgeting and long-range planning tools, Microsoft Excel continues to dominate; it’s frequently used by accounting and finance professionals at businesses of all sizes. > Discover 8 Ways to Make Beautiful Financial Charts in Excel PowerPoint is the most popular choice when it comes to presenting these results. More often than not, people will copy and paste tables and charts from Excel and then add analysis within PowerPoint. However, when data changes in Excel (for example when you receive the new period’s figures from your ERP system), this means you’ll need to manually update all the tables and charts in PowerPoint whilst being as careful as possible not to make any mistakes. This is when individuals want to link their Excel data to PowerPoint. If you’re one of those people, you’re in luck; we’ve asked our UpSlide consultants to explain the three different options for linking data between Excel and PowerPoint, to save you some time: Option 1: Use normal paste options to link Excel data to PowerPoint
Note: Do the same if PowerPoint is already open and you have just opened your modified Excel file.
Limitations for normal Paste optionsIf you move the Excel file to another folder while the PowerPoint file is closed, the link between the chart in the PowerPoint presentation and the data in the Excel spreadsheet will break. Likewise, if you duplicate your Excel file, the link will be broken with the new version. Also note that the update is not available when pasting tables.
Note: The above process works exactly the same for tables. Limitations for Special Paste OptionsThe range of cells pasted into PowerPoint corresponds to a fixed field (example: B2; D10) in the Excel sheet. It means that when you add columns or lines to your tables (example: B2; F15) in Excel, the linked table in your presentation will not extend but will keep the same range of cells (B2; D10) hence providing you with the wrong data. When you go to re-open your PowerPoint presentation, you are asked to update the links. This scenario can happen…
Note: While working on PowerPoint and Excel, if your PowerPoint presentation remains open and you close the Excel file and rename it just after, you will be able to open the Excel source file directly from PowerPoint and update your data. But if you close your PowerPoint presentation while renaming your Excel file, once you open it again you won’t be able to access the Excel source file. Why the native Excel to PowerPoint Link is restrictive for financial controlling or reporting:Imagine you are working on a monthly report (May for example), and you duplicate your Excel file and your PowerPoint presentation to update them with the new figures for June. The PowerPoint presentation for June remains linked to the Excel source file of May. You won’t be able to update your presentation with the duplicated Excel file. > Get to know our Top 3 Productivity Tips to become an Excel Champion Option 3: Use the UpSlide Excel to PowerPoint LinkAs you can see, there are many problems with using the native options when linking Excel to PowerPoint, which is why many people prefer to stick with copy and paste. But manually checking that every figure and comment has been updated properly, plus resizing and aligning tables and charts takes a great deal of time and energy, and opens up the opportunity for errors to occur. So, how can you link PowerPoint to Excel for dynamic data updates? UpSlide is specifically designed to automatically link Excel and PowerPoint. The link enables you to populate PowerPoint from your Excel data and, if you later change the data, you can update your PowerPoint or Word document with the click of a button. Without UpSlide, how long does it take to update a 200 page report? A whole day perhaps? With UpSlide’s fast, robust and flexible Excel to PowerPoint link, it can be done in a few seconds. Benefits of UpSlide’s Excel to PowerPoint Link
With UpSlide, be assured that file sizes are kept 10x lighter than with the native paste. Let’s see in this example. (Presentation weight: Based on 100 simple charts and 100 simple tables). Evidently, UpSlide’s benefits are numerous, including boosting productivity and ensuring data safety. Discover how UpSlide users in Investment Banking save on average 7hrs/month/user with UpSlide’s main features: We’re also constantly developing and improving our link to ensure that we can help our users work better in Microsoft Office. We’ve recently introduced four new advanced options, created based on user feedback, to improve your control over how the link works. > Find out more How to link Power BI to PowerPointDo you find yourself creating more reports in Power BI nowadays? Or, are you considering making the transition to Power BI company-wide? Our Power BI to PowerPoint Link will enable you to leverage your Power BI reports to tell more inspiring stories with your data. . We hope you found this useful. Do let us know what you think in the comments! |