Hi,
We're trying out TM1 version 9.4 32 bit(we currently use 9.1) and having trouble with active forms. I open a cube view and click the active forms icon. Excel (2003) opens a worksheet and an error message box displays: "Cannot empty the clipboard." After clicking "OK" about 25 times to this repeating messagebox the view is eventually displayed in the worksheet. At this point attempting to drill up or down produces the same error.
Any idea what is causing this?
Thank you
"Cannot empty the clipboard" Excel error on active forms
- rkaif
- Community Contributor
- Posts: 328
- Joined: Fri Sep 05, 2008 6:58 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.1 or later
- Excel Version: 2003 or later
Re: "Cannot empty the clipboard" Excel error on active forms
Apparently it looks like a Microsoft error. Please have a look at the following website for a solution:
http://www.online-tech-tips.com/ms-offi ... clipboard/
http://www.online-tech-tips.com/ms-offi ... clipboard/
Cheers!
Rizwan Kaif
Rizwan Kaif
-
- Posts: 2
- Joined: Thu Oct 08, 2009 3:43 pm
- OLAP Product: TM1 version 9.4
- Version: 9.4
- Excel Version: Excel 2003
Re: "Cannot empty the clipboard" Excel error on active forms
I tried suggestions on your link but they didn't work. I forgot to mention that I was connecting remotely to the computer. That was my problem. When I went to the room with the test pc and tried it there were no errors. Thank you for your suggestions.
Cheryl
Cheryl
- stephen waters
- MVP
- Posts: 324
- Joined: Mon Jun 30, 2008 12:59 pm
- OLAP Product: TM1
- Version: 10_2_2
- Excel Version: Excel 2010
Re: "Cannot empty the clipboard" Excel error on active forms
I started getting this problem on some ( but not all) Excel slices after moving to a new pc, (Win 7, Office 2007 and 2010, TM1 9.5.2 FP1). I tried suggestions put forward previously but it didn't help.camartin wrote:... and an error message box displays: "Cannot empty the clipboard." After clicking "OK" ....the view is eventually displayed in the worksheet. "
With help from my colleague Alastair we tracked this down to the skype add-in on my browser ( Chrome). We disabled the add-in and the problem went away.
Some points to note:
- If browser wasn't running the problem didn't appear
- Alastair reproduced the problem with his browser, IE9, so not just Chrome affected.
- From web comments I think it is related to changes MS made in Windows 7 to the clipboard