In this newsletter I shared how one single character in an Excel file name caused linked cells and graphs in PowerPoint to fail. This is an article that I originally posted in my CreateExcelCharts sub-site here.
Author: Dave Paradi
Dave Paradi has over twenty-two years of experience delivering customized training workshops to help business professionals improve their presentations. He has written ten books and over 600 articles on the topic of effective presentations and his ideas have appeared in publications around the world. His focus is on helping corporate professionals visually communicate the messages in their data so they don't overwhelm and confuse executives. Dave is one of fewer than ten people in North America recognized by Microsoft with the Most Valuable Professional Award for his contributions to the Excel, PowerPoint, and Teams communities. His articles and videos on virtual presenting have been viewed over 4.8 million times and liked over 17,000 times on YouTube.
25 Advanced Excel Chart Tips and Tricks (video)
These 25 tips and tricks will help you take your skills in creating Excel charts/graphs to the next level. The techniques apply to all modern versions of Excel (Excel 2013, 2016, 2019, and Excel 365 that is part of Office 365). These tips don’t require VBA, plug-ins, or add-ins so you can apply them right…
How one character in a file name can mess up linking Excel cells or graphs to a PowerPoint slide
I recently had someone contact me asking why the linking between Excel and PowerPoint was not working properly. They had followed my advice in this article & video but it wasn’t working properly. Let me explain the scenario, what I discovered the problem was, and the solution that shows how changing one character in the…
PowerPoint Presentation Best Practices Audit; Issue #455 January 7 2020
The start of a new year is a common time to evaluate where you are and what you want to improve to make this year better than the previous year. If you are looking to make more effective PowerPoint presentations in 2020, I suggest you start with my Effective PowerPoint Presentation Audit. In this audit…
Lining up related column graphs at the horizontal axis
The challenge If you have related column graphs, how do you line them up so the horizontal axis in each graph is aligned? If you’ve ever tried to position the graphs manually in Excel or PowerPoint, you know that it is impossible to do it by trying to drag the graphs into the right position.…
Showing key phrases in social media posts; Issue #454 December 10 2019
As social media becomes more important in organizations, you may want to include social media posts in presentations and highlight key words or phrases. This can be a compliment you want to use to congratulate a team on an event or it could be a complaint that highlights a larger issue that needs to be addressed.…
Training Journal podcast December 6 2019
Dave spoke with Jo Cook on the Training Journal podcast about the results of the 2019 Annoying PowerPoint survey and how training professionals can create more effective PowerPoint presentations.
The “last mile” in data analysis; Issue #453 November 12 2019
The “last mile” is a term that refers to delivering service all the way to the customer’s home, not just close by. It has been a significant challenge for companies like Amazon who deliver packages to people’s homes and for providers of high-speed internet. It is relatively easy to get a truckload of packages to…
2019 Gift List for Presenters; Issue #452 November 12 2019
I’m seeing Black Friday previews and pre-Black Friday sales have started. For the past couple of years I’ve put together a list of the products and services I use and recommend to those looking for gifts to give presenters or business professionals who have to create and deliver presentations as part of their job. I’ve recently updated…
The Globe and Mail October 31, 2019
A few key insights from the results of Dave’s Annoying PowerPoint survey were included in Harvey Schachter’s online Power Points column on October 31, 2019.