There is no way to just continue Excel functionality into a PDF form. PDF forms have their own programming language, everything must be done again. Losing formatting is expected, and probably the least of your problems. I see no reason at all to involve PDF in this work at all. Just have everyone use Excel. The pain and problems will be much less.