Hi,
I am using Excel 2007 & PowerPoint 2007.
I have a workbook which is pretty big (+10mb)
I am creating pivot tables based on a large data set in the spread sheet and then creating pivot charts to represent the data.
In order to present these charts I am using Power point and to automate picking up the graphs I have pasted the graphs as links into the PPT.
It all works the problem is the update process is really slow, when opening PowerPoint and updating the links it looks like it opens the spreadsheet updates a link , closes the spreadsheet, moves to the next link opens the sheet again and so on until all the links are updated.
If I open the spreadsheet before updating the spreadsheet then it locks up.
When creating the sheet initially the links update dynamically and really quickly, is there a way to speed this process up?
Tks
damib
Bookmarks