Hi Guys,
Have tried searching the forum & some experimentation but am a bit stuck on the practical aspects of embeding dynamic excel data in power point and would appreciate some help in getting up & running?
What I want to do is run excel on a laptop and make continuous changes (and saves) to a specific worksheet in a specific workbook.
Then also run powerpoint on the same laptop and display within one slide the contents of 4 excel cells (from the above worksheet) containing numeric data.
Then in a PP slideshow, auto loop this and one other slide continuously on a two second loop.
Plus also display the PP slideshow on a remote monitor.
I have got as far as creating a dynamic link in PP to the excel cells which seems to basically work (the data updates seamlessly in PP as the workbook is updated and subsequently loops) but I am struggling with some issues:
Firstly the only way I seem to be able to get the linked data to work is by embedding in PP what is clearly visible as an excel cell with its existing border & formatting. What I was looking for is a more seamless approach where the data is embeded & uses the PP formatting etc?
Secondly is the above basic concept of running excel and powerpoint together on a laptop a sound one, i.e. will the slideshow presentation keep going whilst the spreadsheet is being worked on?
Does anyone have practical experience of this with some do's & dont's?
Thanks,
Mike
Currently running a Mac with:
Excel 2011 v14
Powerpoint 2011 v14
Have tried searching the forum & some experimentation but am a bit stuck on the practical aspects of embeding dynamic excel data in power point and would appreciate some help in getting up & running?
What I want to do is run excel on a laptop and make continuous changes (and saves) to a specific worksheet in a specific workbook.
Then also run powerpoint on the same laptop and display within one slide the contents of 4 excel cells (from the above worksheet) containing numeric data.
Then in a PP slideshow, auto loop this and one other slide continuously on a two second loop.
Plus also display the PP slideshow on a remote monitor.
I have got as far as creating a dynamic link in PP to the excel cells which seems to basically work (the data updates seamlessly in PP as the workbook is updated and subsequently loops) but I am struggling with some issues:
Firstly the only way I seem to be able to get the linked data to work is by embedding in PP what is clearly visible as an excel cell with its existing border & formatting. What I was looking for is a more seamless approach where the data is embeded & uses the PP formatting etc?
Secondly is the above basic concept of running excel and powerpoint together on a laptop a sound one, i.e. will the slideshow presentation keep going whilst the spreadsheet is being worked on?
Does anyone have practical experience of this with some do's & dont's?
Thanks,
Mike
Currently running a Mac with:
Excel 2011 v14
Powerpoint 2011 v14