how keep excel formulas

Question

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 · Answer

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

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded