I've been trying to get a simple macro to update charts and tables in powerpoint from data in excel (the actual spreadsheet is much bigger - I've created a simple version here). This program works perfectly fine on the Windows version of Excel and Powerpoint and updates flawlessly. When I try to go to the Mac though it crashes both Excel Mac and PowerPoint Mac. I've tried all sorts of different types of code examples and I always end up with the same result.
Maybe I'm missing something simple in how I reference the data objects in PowerPoint? Any/all help would be greatly appreciated. It crashes the system the moment it tries to update the data directly (it opens the file no problem).
I've copied the code below (it won't let me upload a .xlsm file for some reason - i'm getting an error message) and a powerpoint with a few slides that it will update (note: I changed the names of the objects in the Windows version of PowerPoint for easy access).
Here's the code (the italicized bolded text is where it crashes). Note: if I stop the code right before that line and go to the immediate window I can do things like "? pppres.name" and it will give me the right result. but I were to say type in something simple like "? pppres.slides(1).name" then the whole thing also crashes (basically trying to get any data other than the name crashes it).