how keep excel formulas

[Bizy Biz]

Hi,

I have a bookkeeping excel spreadsheet and I want to convert the excel spreadsheet to an editable

PDF document that will keep the entire workbook and formulas intact.

In other words, I an excel spreadsheet I created with all the formulas in each cell.

The 1st sheet is the Sales Page where I enter my sales and then I log in my expenses for each

month (Jan - December) at the end of the year I have the formulas set up to transfer my income and expenses  to the

last page (YTD) which will tell me profit and Loss for the year.

I understand I need to use Java to create a PDF in order to keep the formulas intact. How do I do this?

Do you have a video showing how to do this?

Thanks

[George_Johnson]

You have to use JavaScript to perform the calculations in the PDF, though for simpler calculations you can use the built-in methods to perform calculations. Here's a link to a tutorial that should get you started: https://acrobatusers.com/tutorials/print/how-to-do-not-so-simple-form-calculations