I am trying to convert a PDF to a fillable PDF. I use prepare Form but some fields are not recognized and others are. So I am not sure where is the error. If it is in the Excel file or in the PDF? I do not want to add a thousand new entries for text.
I had similar issues, the lines need to be sometimes darker to be picked up more accurately, sometimes, I end up adding them by hand (Acrobat tool) because I was fed up of trying different options.
I go tthe best results when I created the fields in Word or Excel with a gap between each. I made sure there was a bit of 'empty space' between each so the automatic detection worked without being confused, merging cells or missing some.