Repeat top labels not working

[GreyHippo]

I have a table linked to excel and I am trying to repeat the top labels but I set the property to repeat top labels and it still won't repeat. Could it be something with excel?

I attached the files, in case anyone else would like to try.

[Capt. Computer Crasher]

Take a look at this. It should be fixed.

The problem is when it was linked ALL the cell are assigned the cell style DATA. The repeat only works for HEADER and TITLE cell styles.

To fix this:

If it is a datalink
1. Highlight the cells that are supposed to be header and/or title cells.
2. Right click the highlighted cells, pick locking and then unlocked.
3. Now, highlight the title cells, right-click and pick properties. In the properties window near the top change the cell style and row style to (both) to title.
4. repeat step 3 for the header cells, but change cell style and row style to header.

if the table break is already on then it should change automatically.

if table is not datalinked unlocking should not be necessary.

[GreyHippo]

Thanks Captain, that fixed it.

[Capt. Computer Crasher]

Glad I could help