TM1 Forum

When accessing TM1 via Citrix and trying to navigate an active form the following error is displayed in Excel 2010.
“The Clipboard cannot be emptied. Another program might be using the Clipboard”

This error displays each time a user drills down in an active form, the more levels in the hierarchy the more times the error displays.

The version of Citrix we are using is XenApp 5.0.
The server TM1 is running on is Windows Server 2003 SP2.
Client PCs are running Windows 7 with excel 2010.
TM1 version is 9.5.2 FP2.

We have found a work around to the problem, the error disappears if:
Clipboard mapping is disabled in ICA-tcp Properties.
The problem with this workaround is that it disables the ability to do a standard copy and paste outside of the users Citrix session which is unworkable.
The clipboard error does not occur in RDP or if using a locally installed version of TM1.

Has anyone experienced a similar problem in Citrix and if so were you able to stop the clipboard error appearing?

Any ideas or suggestions would be much appreciated.

FWIW, using active forms on my Citrix setup (6.0, Excel 2003, TM1 9.52 FP2) works fine. In my experience I am more likely to get this error using RDP than Citrix. The internetweb has a host of answers, although there doesn't seem to anything that works for everyone all the time. One thing might be worth trying - are there multiple installs sof Excel/Office on the Citrix server? i.e. a mix of 2010 and previous versions? If so, it could be worth uninstalling all the Excel/Office instances and then re-installing 2010.

Hi Paul.

Thanks you for your reply. Active forms worked fine for us until we upgraded from Excel 2003 to Excel 2010. Yes we are running multiple versions of Excel in Citrix. I will try your suggestion and see if a clean install of excel 2010 only fixes the problem. Tell you if this is successful.

Hi Paul.

Bad news, I have confirmed that the Citrix servers are only running Excel 2010 and no other version of Excel exists on the server. Thanks for the idea but it looks like it is back to the drawing board.

We also have this issue with Excel 2010 and active forms (on standard desktop not Citrix or rdp) but are just "living with it"

awood wrote:Hi Paul.

Bad news, I have confirmed that the Citrix servers are only running Excel 2010 and no other version of Excel exists on the server. Thanks for the idea but it looks like it is back to the drawing board.

Oh well, I guess that would've been too easy.

Did you try the fix described in http://support.citrix.com/article/CTX086028/?

I'm going to be doing some testing on this on my Citrix servers in the near future, so we'll see if I come up with the same problem.

Paul thanks once again for your suggestion I have passed the link over to our Citrix team. I will tell you if they have any success. Please tell me if you’re Citrix testing uncovers a similar problem.

Hopefully some light at the end of the active form tunnel. IBM have opened APAR:PM59930 to look at this problem.

Just wondering if anyone else has got a nice fix to this issue.
It seems to be the one issue I have at the moment stopping my Cognos Express upgrade from going live

IBM gave me this:
They had a another customer who recently had the same issue

"We got Citrix XenApp 6.5 running in house and set it up with Excel 2010 and Perspectives 9.5.2 FP2.
I could easily reproduce the problem with an active form.
I did not have Outlook running on my machine but ran Excel locally.
It didn't happen every time but somewhere between 1 and 10 drills I would get the error.
I had the following setting put on in on the Citrix machine:
To enable read-only Clipboard Mapping, set the following registry key on each XenApp server.
Open the registry and navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Citrix\wfshell\Virtual Clipboard
Create a DWORD value with the value name ReadOnly and value data 1.
Restart the XenApp server.

There are slightly different instructions depending on version. See http://support.citrix.com/article/CTX124356
for more info.

So we are going to build a new citrix server with just CE on it and try this ReadOnly seting.

I proved this in principle by disabling the clipboard locally in citrix using local policy editor but this is a pants solution.

jameswebber wrote:but this is a pants solution.

As opposed to a shirt solution????????

I had this issue inside a Microsoft Virtual Machine.

I know it's a different environment, but it was to do with the clipboard sharing service that the VM used, so it's probably related, since the modern MS VM actually uses remote desktop technology to provide interaction.

I found that if I killed a process called "rdpclip.exe" the error would go away, so I tried disabling clipboard sharing for the VM. That caused the error to disappear.

Of course, I lost the ability to cut and paste between my desktop and the virtual machine, but there must be something screwy about the way TM1 manipulates the clipboard, so it was the only way I could get Excel to remain stable.

Yeah this is definitely a screwy way that TM1 uses the clipboard.
Still waiting for my new citrix server but very hopeful that it fixes it.


Pants like in underpants = rubbish by the way Tomok
http://news.bbc.co.uk/2/hi/uk_news/engl ... 585098.stm

IBM have raised a new APAR for this
https://www-304.ibm.com/support/entdocv ... RXT&mync=E

No fix yet

Apparently fixed in TM1 9.5.2 FP3
http://www-01.ibm.com/support/docview.w ... tus&mync=E

May be a while before this flows down to CE since FP 1 only just came out

This was working fine for me but stopped working all of a sudden today.

Anyone else got this issue coming back again?