Hello,
Could someone indicate me what I'm doing wrong in the below description ?
Or what I could do to improve this very sad "behaviour" ?
Excel 2013, 32 bits
TM1 10.2.2.4
Win 7, 64 bits
I have a Period dimension in TM1 (elements P01 to P12 let's say) and I want to add the month name (Jan ==> Dec) as an alias - without typing the names but rather copy/paste from Excel.
1. Open up Excel from scratch, including the TM1 Perspectives add-in. No Excel sheets are open.
2. Log on to a TM1 model
3. In Excel, I hit Ctrl-N to open a new empty workbook.
4. In cell A1 I type: Jan, and fill down 12 cells to have the short month names. I want to copy these to an alias on a Period dimension in TM1.
5. I press Ctrl-C to copy the 12 cells, I get the well-known error message: "We couldn't free up space on the Clipboard. Another program might be using it right now."
Any comments on this ?
Thanks !
TM1 Perspectives and the clipboard error
-
- MVP
- Posts: 3240
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
TM1 Perspectives and the clipboard error
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Regular Participant
- Posts: 152
- Joined: Sat May 25, 2013 10:32 am
- OLAP Product: TM1
- Version: 9.5.2; 10.2.2
- Excel Version: 2007
Re: TM1 Perspectives and the clipboard error
Hi Wim,
Can you please try option shown in below url
http://superuser.com/questions/703767/e ... am-might-b
Regards,
Deepak Jain
Can you please try option shown in below url
http://superuser.com/questions/703767/e ... am-might-b
Regards,
Deepak Jain
-
- MVP
- Posts: 3240
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TM1 Perspectives and the clipboard error
Thank you, I will have a look at it.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- MVP
- Posts: 3240
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: TM1 Perspectives and the clipboard error
That simple change appears to be working... Me happy 

Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly