linking an excell cell to a powerpoint slide

**dsuthoff** · 02-18-2013, 11:43 AM

I am using an excel spread sheet as a larger display on a huge projected screen with numbers at a large charity event. It is a reverse raffle, so as your name is called you are out of the raffle. I would like to link the cell to a specific powerpoint slide which has the name and town of the specific ticket buyer. When double clicking on the cell listing their number the ticket buyers name and town would appear as a powerpoint a window in the middlle of the excel screen for all to see and then disappear after a few seconds or disappear when the next cell is double clicked.
I can find all sorts of help with putting excel data into powerpoint slldes but not the other way around!

**xenixman** · 02-18-2013, 04:08 PM

You could use the =HYPERLINK() function to access the PowerPoint document and you can even =HYPERLINK() to a specific slide,
IF you have saved your PowerPoint as a .PPS or .PPSX file type.
If you have it as a .PPT format, it will not work.

Then a formula such as: =HYPERLINK("C:\Users\Name\Documents\MyDocument.pps#10","My Link")

Note the Pound Sign # followed by the slide number
This will open the Powerpoint to slide # 10.

**dsuthoff** · 02-19-2013, 12:33 PM

Thanks I will try it/ Will the slide open over the whole excel screen or will it open in a window centered on the excel screen, covering part of it? I would imagine it depends on your settings in the powerpoint program.

**dsuthoff** · 03-17-2013, 05:37 PM

We had our event and I wish I would have done this sooner. When i click on a link the ensuing PP slide covers the whole screen and that is not what I had envisioned BUT I do not think that will be a problem. Now I am going to look at trying to make every cell in display page line up on another display in the order they are "clicked" (or drawn out).

The multiple monitor setup I tried to use with a power show add on in power point was a disaster!!

**dsuthoff** · 03-17-2013, 05:42 PM

Basically I am trying to figure out how to take 300 cells in excel and if they are randonlly clicked - the name they represent would line up in numerically order on another screen or window

**xenixman** · 03-17-2013, 06:05 PM

Sorry to hear you presentation didn't go well.

if they are randomly clicked - the name they represent would line up in numerically order on another screen or window

No sure if that is possible.

The only other suggestion is that you do not have to "hard code" the slide number in the formula.

If you have your slide numbers in B1:B300 then something like:

=HYPERLINK("C:\Users\Name\Documents\MyDocument.pps#"&B1,"Jump to Slide "&B1)

Drag down 300 rows

When I do it only my machine, the slide always fills the screen.
Don't know if it is possible to change that behavior, haven't really played with it that much.

**dsuthoff** · 03-17-2013, 06:12 PM

When you look at the evening - We raised a lot of money and had numerous techinical problems we worked through succesfully so the evening was "succesfull" - but it was not the smooth visual stunning evening I had hoped for. There was a lot learned and I am looking forward to next year.

not sure what you mean

but I will try to figure it out for awhile

**dsuthoff** · 03-17-2013, 06:26 PM

When you look at the evening - We raised a lot of money and had numerous techinical problems we worked through succesfully so the evening was "succesfull" - but it was not the smooth visual stunning evening I had hoped for. There was a lot learned and I am looking forward to next year.

not sure what you mean

but I will try to figure it out for awhile