Welcome Dialog

Welcome to the Community!

We have a brand new look! Take a tour with us and explore the latest updates on Adobe Support Community.


HOW TO CONVERT EXCEL SHEETS TO PDF KEEPING THE CALCULATIONS?

New Here ,
Jul 06, 2021 Jul 06, 2021

Copy link to clipboard

Copied

Helo Community, can any body please help me? in How to convert Excel Spreadsheets to PDF keeping the calculations?

Thanks.

7/6/2021

TOPICS
PDF forms

Views

36

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jul 06, 2021 Jul 06, 2021

Copy link to clipboard

Copied

Convert the file into PDF and add the calculations in Adobe Acrobat.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jul 06, 2021 Jul 06, 2021

Copy link to clipboard

Copied

Calculations done in Microsoft Excel will be lost when converting the spreadsheet file  to a PDF file.

 

The Microsoft Office family use Macro functions , such as some of your formulas in MS Excel.

 

These macros are developed with Visual Basic for Applications (VBA), a computer programmming language owned and developed by Micrososft, which also has become the standard accross all MS Office programs.

 

Even though you can implement JavaScript for MS Office using some very complicated frameworks, the same is not true with VBA; it is exclusive to MS Office.

 

In the same context, Acrobat JavaScript is exclusive to the Adobe Acrobat program; as indicated by Bernd Alheit, you must manually develop the script(s) that would calculate in the same way as  the  macros used in your spreadsheet but using Acrobat JavaScript.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jul 06, 2021 Jul 06, 2021

Copy link to clipboard

Copied

Thank both of you very much.

Its kind of complicated. So, there's nothing that I can do about it!

Thanks a lot, agian for your help.

RAMFTKEY

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jul 06, 2021 Jul 06, 2021

Copy link to clipboard

Copied

LATEST

If you're ok posting your formulas we may be able to assist you with the Acrobat JavaScript scripting part, but if this is a complicated spreadsheet I'd suggest you are better off outsourcing a developer that can do that for you for reasonable fee.

 

 

 

 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines