Table headers not repeating across top of table linked to Excel file

[RockyBrown4134]

I am having problems with a table linked to an Excell Sheet. The Title and Header rows will not repeat when I enable page breaks. Property settings are as follows:

Enabled: Yes

Direction: Down

Repeat  top labels: Yes

Repeat bottom labels: No

Manual Positions: No

Manual heights: Yes

Break height: 24"

Spacing: 1"

Data ling is to a range of cells: A1:I215, I even save it back down to an ".xls" from an ".xlsx" file.

Any suggestions?

Thanks.

[zalant · Accepted solution]

What you're encountering is designed (albeit unexpected) behavior.  Fortunately, there's a fairly simple workaround.  Instead of inserting a table and choosing "From a data link", go with "Start from an empty table".  I don't think that the amount of columns/rows matters, but I haven't tested it that much.  Once you have the new blank (non-linked) table inserted, click in the first cell.  Right-click, click Data Link, and choose the data link you had set up for the Excel file.  That should do it.  You can then edit the table, setting it to allow breaking and all of those other options.

[RockyBrown4134]

Thanks.

That worked great!