Not able to create Form in Numbers

I might have solved it or at least found a workaround. I started by copying bigger and bigger sections of the sheet starting from the top (including the headers) and going down and then pasting it into a new document, then checking if it would allow me to create a form. It worked all the way until I copied the last page/section of the logbook. I got the same result if I pressed CMD+A and pasted it in a new document, it wouldn't work. But as long as I omitted the last section it worked.

You might think that there was something wrong with the last section but that is not the case as I even increased the amount of rows from roughly 1300 to 5600 just to see if there was a limitation with the amount of rows. Again, even with the now much bigger sheet it only worked if I omitted the last section/page of the logbook.

To summarize I cant see any other reason than this being a bug in Numbers as it clearly has nothing to do with the complexity nor the size of the spreadsheet. I'll will test it some more and get back should other issues arise. Many thanks for all the replies!

I simply type in a bunch of spaces before the text "Route of Flight" in the first cell (far left), that forces the text to appear over the cells to the right of the cell containing the text.

As mentioned in the original post I have marked the whole table and selected to clear all merged cells. And since the program allows me to select the table as a source for the form once I remove some of the cells (not just specific ones) should indicate that there are no merged cells. It just seems that the table isn't simple enough to be used with a form but I can't find any info to support that.

Hi Jason, as mentioned no cells are merged. What you’re perceiving as a merged cell is simply multiple cells without boarders and the text within is just centered to make it look as if the cells are merged.

Thanks for the reply!

No I haven’t since I need 3 header rows. They are locked in place so when I scroll down thru the logbook the headers always appear on top.

However it does work with 3 headers as long as I remove some of the table somewhere else.