![]() ![]() I've searched for a solution but to no avail. ![]() After that, the Macro dialog box will open. You will see the Macros button to the right. If I also send the Excel file they still cannot edit the charts without changing the links to the location they save the file in - which is not a workable solution. From there, you can open the Macro dialog box and edit the macros. From the macro settings, select the extent of permission to be granted. The problem I have is that if I just send the PowerPoint file to colleagues they cannot edit the charts. In the Excel options dialog box, click trust center settings in the trust center option. To create a country presentation I save a copy of the PowerPoint presentation and the Excel file - one copy for each country - and then change the country on the data sheet so the presentation updates (after updating the links in the file using a macro). I then have a PowerPoint presentation that contains approximately 30 charts that are linked to the datasheet. To do this I have created an Excel file that contains data for all countries and a datasheet that uses vlookups to pull through the data for one country at a time. I need to replicate a PowerPoint presentation across multiple countries then send the presentations to colleagues and give them the ability to edit charts. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |