Convert an Excel Form with Formulas and Macros into a Fillable PDF
Question details
The user wants to convert an Excel form into a fillable PDF that calculates results from entered numbers.

- Product
- Microsoft Excel and Adobe Acrobat
- Device & OS
- not provided
- Scenario
- An Excel form contains formulas, unlocked input fields, macros, and password protection and needs to be distributed as a fillable PDF.
- Observed behavior
- The desired PDF should accept user input and calculate results while providing appropriate form security.
Identify the Excel input cells, formulas, macro actions, and protection requirements before exporting the form. Check that your Acrobat edition and version support the form-authoring and JavaScript features you need.
Create PDF form fields and rebuild calculations in Acrobat
Use this approach to preserve the form layout and manually recreate calculations after exporting from Excel.
Exporting an Excel sheet to PDF does not automatically convert its formulas or VBA macros into Acrobat JavaScript. Excel cell protection and passwords also do not automatically become equivalent PDF form permissions.
Open the workbook in Excel and use File > Save As or File > Export to create a PDF of the form. Check that the input areas and labels are visible in the exported file.
Open the PDF in Acrobat and choose All tools > Prepare a form. Let Acrobat detect fields if available, then add or adjust text fields using the form toolbar and give each field a meaningful name.
Open a result field's Properties, select the Calculate tab, and use a built-in calculation or a custom calculation script. For example, multiply fields named Quantity and Price with: event.value = (Number(this.getField('Quantity').value) || 0) * (Number(this.getField('Price').value) || 0);
Rebuild any required macro behavior using supported Acrobat form actions or JavaScript. Configure PDF security and permissions in Acrobat as needed; some Excel macro functions may have no direct PDF equivalent.
Save the PDF, open it in the intended PDF reader, and enter sample values into the fields. Check calculations, field permissions, and any scripted actions; the reader must support and allow the JavaScript used.

Prepare Excel Forms for PDF Export with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Microsoft Office files and exporting a form layout to PDF. Recreating interactive calculations and macro behavior still requires a capable PDF form editor.

Frequently Asked Questions
Will Excel formulas automatically work in the exported PDF?
No. Exporting the worksheet preserves the visible layout, but formulas must be recreated in PDF form fields using Acrobat's Calculate options or custom JavaScript.
Can Acrobat convert Excel VBA macros into PDF JavaScript?
No. Review each macro and recreate the needed behavior with Acrobat form actions or JavaScript where possible. Some Excel-specific functions may not have a direct PDF equivalent.
How do I add a calculated total to a PDF form?
In Acrobat, open All tools > Prepare a form, create the input and result fields, and open the result field's Properties > Calculate tab. Choose a built-in calculation or enter a custom calculation script.
Does Excel sheet protection carry over to the PDF?
Excel sheet protection does not automatically become equivalent PDF security. Configure the PDF's security and form permissions separately in Acrobat, and test that intended users can fill in the fields.
Why might a calculated field not update for a recipient?
Check the field names and calculation settings in Acrobat, then test the form in the recipient's PDF reader. The reader must support and allow any JavaScript used by the calculation.




