J
Joao (Portugal)
Hi,
I've been searching the net for this issue and came to some payed
replacers, but no answers from microsoft.
In Powerpoint 2003, if we inserted a linked Excel sheet that link was
a relative one.
We do the same in PPT 2007, with Excel 2007 and it's a absolute link.
Now I've read the trick to export/publish the PPT to a CD in order to
convert the links from absolute to relative... I've tried it and it's
unpracticable with 45 links (to 45 Pivot tables).
Seams also cumbertone that in Excel if you referer several cell from
an external spreadsheet it's only one link you need to change; but in
powerpoint those several links to cells from one sheet will be come
several links.
And it's curious that I have another presentation where I mantain like
40 absolute links and 5 relative links to an Excel sheet.
The next nightmare is when I open the presentation (with the 45 links)
that even when I say not to update links, It will try to open 45 times
the Excel sheet. It's so cumberstone that I need to open the Excel
sheet before I open the presentation, even if I say not to update.
Imagine the cenario when you create tens of presentations like this
for people, in which the sole diference between the PPTs is some
parameters in the SP/query that feeds the pivot tables:
- make a copy of the .xlxs and .pptx to a new folder
- open the older .xlsx (in the original folder) so speed up the
new .pptx opening
- open the new .pptx, and say not to update links - anyway it will
try to open the old .xlsx 45 times, but it's ok because it's open
- go to prepare and edit links to files, and change origin selectting
45 times a .xlsx from the current folder.
- now close the older .xlsx and open the .xlsx it the new folder.
- go to data and change the SP/queries parameters, and save .xlsx
- save the pptx, close it and reopen it (the absoute links are now
pointing to the new xlsx) and choose update links (we've updated the
45 pivot tables after changing the links).
- and finally repeat this tens of times.
I'm sorry for my bad english, and for the size of the post, but I
haven't seen anyone before complaning about this issue in Office 2007.
Thank you in advance for a MVP that can look into my ''little"
problem,
João Ferreira (Lisboa - Portugal)
I've been searching the net for this issue and came to some payed
replacers, but no answers from microsoft.
In Powerpoint 2003, if we inserted a linked Excel sheet that link was
a relative one.
We do the same in PPT 2007, with Excel 2007 and it's a absolute link.
Now I've read the trick to export/publish the PPT to a CD in order to
convert the links from absolute to relative... I've tried it and it's
unpracticable with 45 links (to 45 Pivot tables).
Seams also cumbertone that in Excel if you referer several cell from
an external spreadsheet it's only one link you need to change; but in
powerpoint those several links to cells from one sheet will be come
several links.
And it's curious that I have another presentation where I mantain like
40 absolute links and 5 relative links to an Excel sheet.
The next nightmare is when I open the presentation (with the 45 links)
that even when I say not to update links, It will try to open 45 times
the Excel sheet. It's so cumberstone that I need to open the Excel
sheet before I open the presentation, even if I say not to update.
Imagine the cenario when you create tens of presentations like this
for people, in which the sole diference between the PPTs is some
parameters in the SP/query that feeds the pivot tables:
- make a copy of the .xlxs and .pptx to a new folder
- open the older .xlsx (in the original folder) so speed up the
new .pptx opening
- open the new .pptx, and say not to update links - anyway it will
try to open the old .xlsx 45 times, but it's ok because it's open
- go to prepare and edit links to files, and change origin selectting
45 times a .xlsx from the current folder.
- now close the older .xlsx and open the .xlsx it the new folder.
- go to data and change the SP/queries parameters, and save .xlsx
- save the pptx, close it and reopen it (the absoute links are now
pointing to the new xlsx) and choose update links (we've updated the
45 pivot tables after changing the links).
- and finally repeat this tens of times.
I'm sorry for my bad english, and for the size of the post, but I
haven't seen anyone before complaning about this issue in Office 2007.
Thank you in advance for a MVP that can look into my ''little"
problem,
João Ferreira (Lisboa - Portugal)