I've inserted a table using a data link to an excel file. I've enabled breaking and repeat top labels. When I break the table into two, it does not repeat the header row. I've gone into the table and noticed that the header row is set to data so I changed that to header and still no luck. I can split a table if I create it from scratch but not from an excel file. Seems odd, must be a glitch?
I have seen this issue across these forums before. I just worked around it by either copying the top label cells to the split table or creating a new table and just using the range option to insert the top labels. I just can't remember which at the moment. I know this doesn't fix it but I wasted more time searching for a solution than just doing what I had to do to get the job done. HTH.
Thanks Jason. That did the trick. I had been trying to select the row(s) and right click but the format options were grayed out. I just needed to look at the properties list for row style instead.
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register