Hi,



I have the following problem:
- There is a daily meeting in our company which makes use of a ppt with KPIs
from all different areas.
- This ppt has diagrams pasted as links from an underlying Excel file; A macro
in the ppt updates these links and archives the entire ppt as a pdf file.
- In the underlying Excel file, there is another macro which, however, only
opens a nr. of other files so that formulas in that core_file can draw values,
then the core_file is saved and all the source_files are closed. Afterwards,
the macro opens the ppt and triggers that second macro.
- There is one diagram in the core_Excel which is the problem: The scale is in €
there, set to "Currency" with the €-sign explicitly set
<=> in the ppt, it was in $ for I don't know what reason.
- I deleted the diagram in the ppt and pasted the link again, it was fine
<=> then I triggered all the macros and although the one in ppt does
nothing save update all the links, afterwards the scale in ppt was in $
again (while in the underlying Excel, it was still €)

=> As nothing changes in the Excel, it has to be something in Powerpoint that causes the unit to change. Does anyone here have an idea what could be happening there?

Thanks a lot!

Best regards,

Officer_Bierschnitt

Hi,

I am at my wit's end about this.
There are, I believe, three places in the diagram in Excel where I can right-click and select "Format axis" - everywhere I have set the number_format to "Currency" and explicitly selected the €-symbol.
Still, in the ppt, the figures are formatted with the $-symbol.

Okay,

I think I finally solved this. I just found one more place in the diagram in Excel (the FOURTH) where I can set the number_formatting. I set it to Currency, too - what perfidy is that, giving the user several places for the same setting, with one potentially overruling the others ...
It looks good now, even after running the macro several times - but it was so yesterday, so I'll wait till tomorrow.

Best regards,

Officer_Bierschnitt