Hi,
we just upgrade our TM1 from 9.4 to 10.2. Now we face a problem: runtime error 1004: method 'DisplayAlerts' of object '_Application' failed.
The scenario is:
1. Open TM1 Perspective through Excel
2. Create one powerpoint file.
3. Insert one Excel table to powerpoint file. Set this excel table->Formulas->Calculation Options->Manual
4. Focus the mouse one the Excel Table. Then click F9 button
The error message shows up:
runtime error 1004: method 'DisplayAlerts' of object '_Application' failed
If I don't open TM1 Perspective 10.2, and perform the same steps above, click F9 will not triger the error. And when we have the old TM1 9.4, we never see such error.
Could some one help me to solve the problem?
One tip here: if don't set excel table->Formulas->Calculation Options to "Manual", just take the default "Automatic", the Excel table embedded in powerpoint will be calculated automatically, and no error pops up.
Best regards,
Learn_TM1
runtime error 1004: method 'DisplayAlerts' of object '_Application' failed
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: runtime error 1004: method 'DisplayAlerts' of object '_Application' failed
It wouldn't surprise me if it's the same issue with corrupted .exd files as is described in this thread.Learn_TM1 wrote: The error message shows up:
runtime error 1004: method 'DisplayAlerts' of object '_Application' failed
If I don't open TM1 Perspective 10.2, and perform the same steps above, click F9 will not triger the error. And when we have the old TM1 9.4, we never see such error.
Could some one help me to solve the problem?
Close down all of your Office products and get rid of any .exd (temporary ActiveX) files that you can find on your system and see whether that fixes it.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
Learn_TM1
- Posts: 42
- Joined: Mon Sep 21, 2015 2:24 pm
- OLAP Product: Cognos TM1
- Version: 10.2.2
- Excel Version: Excel 2010
Re: runtime error 1004: method 'DisplayAlerts' of object '_Application' failed
Hi Alan,
Thanks for your reply. I also read the the thread in your post. I tried the following scenario:
1. Remove all *.exd files in my computer, then execute the steps in my initial post. The error still pops up
2. Get a new computer, which has no *.exd in it. Then install TM1 10.2, execute the steps as above. The error still exists.
What should I do further more?
Best regards,
Learn_TM1
Thanks for your reply. I also read the the thread in your post. I tried the following scenario:
1. Remove all *.exd files in my computer, then execute the steps in my initial post. The error still pops up
2. Get a new computer, which has no *.exd in it. Then install TM1 10.2, execute the steps as above. The error still exists.
What should I do further more?
Best regards,
Learn_TM1