View Single Post
 
Old 01-13-2016, 02:11 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Oct 2015
Posts: 87
Officer_Bierschnitt is on a distinguished road
Default Unit is $, should be € - why is it being changed?

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
Reply With Quote