How keep excel formula after converting to pdf

%3CLINGO-SUB%20id%3D%22lingo-sub-1599729%22%20slang%3D%22en-US%22%3EHow%20keep%20excel%20formula%20after%20converting%20to%20pdf%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1599729%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20convert%20a%20project%20report%20from%20excel%20to%20pdf.%20However%20I%20want%20to%20make%20provision%20to%20change%20some%20field%20which%20will%20result%20in%20changing%20of%20all%20the%20other%20linked%20field%20throughout%20the%20report%20(like%20excel%20sheet)%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.farmingindia.in%2Fdpr%2Fdairy-farm-project-report-pdf%2F%3Fgclid%3DCjwKCAjwm_P5BRAhEiwAwRzSO91OTTqM9HEo87fcHscMH4mzH4GbQ-_1ZfJA1pN85jM0GEYy5lm8cRoC6OoQAvD_BwE%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EPlease%20see%20the%20example%20here%26nbsp%3B%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20how%20to%20do%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1599729%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1599820%22%20slang%3D%22en-US%22%3ERe%3A%20How%20keep%20excel%20formula%20after%20converting%20to%20pdf%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1599820%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F764941%22%20target%3D%22_blank%22%3E%40santhosh785%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EA%20PDF%20file%20is%20like%20a%20printed%20version%20of%20the%20workbook.%20It%20does%20not%2C%20and%20cannot%2C%20contain%20formulas.%20So%20what%20you%20want%20is%20impossible.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 excel sheet)

Please see the example here  

Please let me know how to do this.

5 Replies

@santhosh785 

A PDF file is like a printed version of the workbook. It does not, and cannot, contain formulas. So what you want is impossible.

@santhosh785 

Just in case, that's a comment on the site you mentioned

---

MS Excel is a very good file format when it comes to tabular data and mathematical calculation. But the problem with MS Excel is that you can not combine text with tabular data in a beautiful way. That’s why our project reports are based on editable PDF file format(YES, editable with automatic calculations like Excel) which will not only allow you to change the project report data as per your needs(like Excel) but also represent the whole report in a well formatted printable file.

@Hans Vogelaar 

Please visit the site I mentioned. They have done  it. IF it is impossible, how could they do it

@santhosh785 

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.

@santhosh785 

It can be done using Adobe Acrobat X or later I think

calculations in pdf though are limited to sum and product and some simple things, not as complicated as an excel sheet, please find the example attached.