How to repeat elements

[former_member254358]

Hello,

I have excel 2013 and the repeat elements option is present in the components tab. However, this option does not exist in excel 2007 and excel 2010.

Looking for information it seems that this option exists but I don't know where to find this one.

Can anybody help me?

Thanks in advance.

Regards.

[Former Member]

Hi David,

I had troubles with some elements not appearing due to a windows display :

the DPI was not set to default value 100% in Control Panel\Appearance and Personalization\Display

Hope this helps

Christophe

[former_member254358]

Hi Christophe,

in my case the default value is 100%

Thanks.

[Former Member]

OK,  did you tried to display "by sheet" or "por "hoja" to see wether you can see the ITEM_GRID

[former_member254358]

The same.

Thanks.

[former_member110741]

Hi David Roig,

from above screen shot, you selected "Book"

could you try selecting Crosstab and Book->DS_1->Crosstab 1 and check ?

Regards,

Subhash

[former_member254358]

Hi Subhash,

that is the problem. I can only see the book. With the excel 2013 I have all, Book->DS_1->Crosstab

Thanks.

[TammyPowlas]

It's there

You have to be in the Components tab, select Crosstab and shown below in the screen shot:

I am using Excel 2010.

[former_member254358]

Thanks for your reply.

It's the same with excel 2013 but, I don't know why, in 2007 and 2010 in the components tab I only see the Book1 and 5 options for being chosen.

The last option is "Merge variables".

I have just fount the following link:

http://help.sap.com/businessobject/product_guides/AMS12/en/12_aaoffice_whatsnew_sp3_en.pdf

Perhaps it's a version problem and the Repeat elements has disappeared.

My version is 1.4.7.3073

Any suggestion?

[TammyPowlas]

I am using the same version as you with Excel 2010

Could you post a screenshot of where you are expecting it?  Use the camera icon to upload

[former_member254358]

Sorry my excel is in spanish but I think it would be the same in english

[TammyPowlas]

Hi David - could you enlarge the screen capture - I need to see the full Display panel - and no problem if in Spanish

[former_member254358]

[TammyPowlas]

Could it be authorizations?  That is strange not to see it expand.  Could you try it with admin access?

[former_member254358]

No. The same with my user that has admin access

[TammyPowlas]

Hi David - I recommend submitting a SAP incident with support - something is not right here with this tab that it is not expanding to show the crosstab so you can repeat members.

[former_member254358]

Thanks a lot Tammy for your help.

[TammyPowlas]

One more idea is to install SP08 of 1.4 - just released today - see http://service.sap.com/sap/support/notes/1910505 > not that it would solve it but it could...

[former_member254358]

Thanks Tammy,

we will wait until to have the new realese. I will tell you if the new sp fix the problem.

Regards.