Good day

I am trying to colour blocks in PowerPoint based on the colour of cells in Excel. Essentially what I am doing is using a table in Excel and updating these values (not too regularly). Based on the cell value in Excel, I would like the block in PowerPoint to be a certain colour.

My initial thought was to use a conditional formatting method to change the cell colour in Excel, and then copy that same colour (using RGB numbers) to PowerPoint using a macro.

Would this be possible? I have not yet got around to trying to write the macro as I thought I may find a skeleton upon which to develop my solution.

Thanks in advance!

Laevashan

Dear Experts,

I have a user which started to have an issue with opening ppt files this week over vpn.
The strange thing is it's only happening with ppt files, pptx are opening fine.
If I copy the ppt file from the Shared drive to the desktop it takes 3-4 Seconds to copy and around 10 seconds to open.
If I open the same ppt file directly from a network share it takes around 3-4 Minutes to open or Powerpoint is even crashing.
The same files are opening fast when on the Office network.
I'm running out of ideas what could be the issue.
I tried the following until now:

- repair office
- Adjust MTU of the Wifi adapter
- start Powerpoint in safe mode
- disable all Add-ins
- Add network share in the trust center to trusted locations (including subfolders)

It's still the same after all this.

the following is used:
- Windows 7 64 Bit
- Office 2013
- Cisco Anyconnect

Best Regards and many thanks in advance for any input,

Patrick

I am trying to get the attached “Section Exclusion Manager” to work for Powerpoint. The idea is to open a Powerpoint file that contains sections, save a user-defined copy of that file, display the section names and starting page numbers of the copy in the first picklist, move selected sections from that picklist to the second picklist, and then delete those sections from the file.

I have the code working for saving a copy in the same directory as the source and reading the section data into an array, but cannot get the first picklist to read and display that array (in Sub PopulateSourceList). Since I can’t do that, I can’t get the user selections to display in the second picklist, nor to then delete the sections from the copy. Have some code attempts to display sections in the picklist but they're not working. Can someone help with these three functions?

 Userform, code and sample source file (with sections) are attached as ‘Section Exclusion Manager PowerPoint (Test July 6 2017)’ and ‘PowerPoint Section Test’.
Section-Exclusion-Manager-PowerPoint.ppt
PowerPoint-Section-Test.pptx

When I have a PowerPoint file open... using two screens
And hit F5 so the Show runs...
I see a "timer" running in top left of screen?
Is that a countdown to the slide changing?
Or a count of how long it HAS been running.

I do NOT want it to change automatically.  This is manual click only

how to modify the excel file of PPT's chart data  via PPT macro which takes input of a ID from a button on PPT slide and arrange data accordingly. Lets say I have a chart on slide 2, I want to automate that chart. I want a command button, which on click asks the customer ID for which we want to see the chart. and after entering the ID, the data excel file of chart automatically changes the data. I wrote a code in chart data excel file VBA which changes data according to the ID, but I am unable to get the input from PPT file and make that excel file run the code. Basically I am unable to connect the PPT VBA to that chart data excel file or it's chart data excel's VBA

I'm unable to play ANY audio files in PowerPoint 2016. If I play these outside of PowerPoint using Windows Media Player, QuickTime or DivX, they all work fine. I can insert a movie into a slide and it'll play fine but no sound. Insert a WAV or MP3 and it looks like it's playing OK but just no sound. I insert a link to an external YouTube clip and that did play the movie with sound OK. To eliminate a corrupt PowerPoint file, I've created a brand-new file with the same results. I've tested a file that doesn’t work within PowerPoint in PowerPoint Viewer and that plays the sound OK so I then ran a repair of the MS Office which didn’t fix the problem. Knowing that it must be a PowerPoint issue, I then completely uninstalled Office before re-installing but still the same problem. I've now completely run out of ideas. With previous versions of PowerPoint I could resolve this kind of issue by installing a Codec pack but I'm at a loss with this version. Help most welcomed.

Hi Experts,
Could you pls advise, Is there a way to create animated flow chart. Basically trying create flowchart with animation on button click.

I know Microsoft PowerPoint and prezi has some capabilities but trying to get some advise if there is a better way to do it. :)

License product is also fine. we can look those options as well. :)

Thanks in advance

I am trying to build a userform that enables one to select a Powerpoint file, display its section numbers in a listbox, and allow one to selected sections to remove from that listbox (which would then go to a second listbox) and have the macro delete those sections from the copy. I've attached code that copies a Powerpoint file with all of its slides but the code does not copy the sections. So I thought a two-dimensional array that captures the section names and first slides would suffice, so that I could use that array to create the same section names and first slides in the copy --  assuming that I could figure out how to get the firstslide number(s) from the user selections and then delete those sections from the copy. But I cannot figure out how to build this array. I can loop through the sections and get their names and firstslides, but not how to populate the array with that data and then use it to delete whichever sections are chosen from the second listbox. Can someone help get me started?

I had this question after viewing VBA to change source of links in PowerPoint.

I tried this code in PowerPoint 2013 but it doesn't seem to word there, any suggestion of how can we link all the links to a different Excel file or folder?

This is weird.

I just opened a narrated project I successfully completed a few months ago and when starting the slide show on a specific slide, the audio narration is silent. All audio narrations (recorded in a studio and output to MP3 format) are set to be hidden during the slide show so I unhid one and looked to see what was happening during the slide show:
Now the even weirder thing is that these audio files play perfectly fine when in edit mode (out of slide show mode) and, they play ok when starting the slide show on a different slide and then transitioning to the slide in question (checked with several narrated slides). The audio will not play when using Shift+F5 to start the slide show on a specific narrated slide. Or, I can use Shift+F5 to start on a specific slide, go back one slide then forward one slide and the audio then plays.

The animation pane is set to play each of the narration audio file automatically, After Previous, without a delay and are the first effect in the animation sequence.

After more testing, I found that the audio did play sometimes but mostly did not so it's even intermittent! What is going on?

PowerPoint 2016 (PC) 32 bit, Account Version : 1704 Build 8067.2115 Click-to-Run, About Version : 16.0.8067.2115

Hi,

Is it possible to share a Goole slide deck with someone and force it full screen?

I don't want the viewer to see the thumbs slides on the side and I need to make sure it is viewed in presentation mode, otherwise the deck will not make sense as i have several images and text that need to animate over each other. If you it view it without 'Presenation' mode, the graphics and text and all mumbled on top of each other.

Thanks in advance for your help.

I am using MS Office 2013, and am trying to make a PowerPoint presentation which will be shown to the class using a projector connected via VGA. Within the slides,  I have inserted both objects and hyperlinks within text boxes to show specific pdf's and word doc's as examples of the information on my slide. I want to use presenter view in MS PowerPoint and not duplicate my screen to the class.
However, as I am doing a trial run of my presentation, the results are as follows:
Test #1 - Hyperlink: I am only able to open a hyperlink within slideshow view ( in which I have selected presenter view). When I click on the hyperlink, it only opens on my laptop and the projected image stays on the slide (which contained the hyperlinks).  Results: I cannot show the hyperlinked pdf to the class, even with alt + tab.
Test #2 - Object: I inserted the object of the same pdf image as test 1. However, when using presenter view, I cannot click on the object to open it. I have to press Escape and open the object from outside of the slideshow view. Meanwhile, the class is seeing the view of my laptop desktop which I do not want.

Is there any solution to this?? Please help and advise me on how to use presenter view in MS PowerPoint 2013 and open hyperlinks to show the class in a seamless way and not show the class my desktop.

I've built a PowerPoint toolbar for my company using VBA, one feature of which is to insert/change the background image of the currently selected slide.  It displays a File Picker dialog pointed to a specific folder in the corporate content library which contains over 1100 JPG images, the user chooses an image, then the code makes that image the background fill for the current slide.  Works great.

To aid in searching the collection, our corporate design team has added numerous tags to each of these .jpg pictures.  In a webpage environment the tags work as expected.  

But when inserting pictures into PowerPoint the tags behave differently.  You would assume that the search box in the upper right of this dialog would find not only pictures with the search term in the filename, but ALSO pictures where the search term is found in the file tags.  In fact you can see in the first image below it is highlighting a couple images where it matched "meeting" in the tags.  


But on closer inspection, I realize it is only showing files where the search term appears in BOTH the filename and the tags.  If I pick a word that is only in the tags, like "Toothy," which we know from the first image is in the tags, the search does not find any matching images, because Toothy is never in any filenames.

BTW, this behaves the same way whether using my macro code, or manually inserting picture from the regular PowerPoint menu.

I would …