Forum Discussion
santhosh785
Aug 19, 2020Copper Contributor
How keep excel formula after converting to pdf
I want to convert a project report from excel to pdf. However I want to make provision to change some field which will result in changing of all the other linked field throughout the report (like exc...
HansVogelaar
Aug 19, 2020MVP
A PDF file is like a printed version of the workbook. It does not, and cannot, contain formulas. So what you want is impossible.
- notarydaveAug 11, 2021Copper Contributor
Check this out:
https://www.howtogeek.com/665728/how-to-create-pdf-forms-with-calculations-in-adobe-acrobat/
- santhosh785Aug 20, 2020Copper Contributor
Please visit the site I mentioned. They have done it. IF it is impossible, how could they do it
- HansVogelaarAug 23, 2020MVP
It is possible to create a form with calculations in PDF (using Java or something like that), but you'd have to create it from scratch. As far as I know there is no way to convert an Excel workbook to PDF while retaining the formulas.