Skip to main content
Participant
July 6, 2021
Question

HOW TO CONVERT EXCEL SHEETS TO PDF KEEPING THE CALCULATIONS?

  • July 6, 2021
  • 2 replies
  • 1074 views

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

Thanks.

7/6/2021

This topic has been closed for replies.

2 replies

ls_rbls
Community Expert
Community Expert
July 6, 2021

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.

RAMFTKEYAuthor
Participant
July 6, 2021

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

ls_rbls
Community Expert
Community Expert
July 6, 2021

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.

 

 

 

 

Bernd Alheit
Community Expert
Community Expert
July 6, 2021

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