Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to convert a Microsoft Excel Worksheet as a PDF Form

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 11-01-2012
Member
 
Join Date: Jan 2012
Posts: 21
How to convert a Microsoft Excel Worksheet as a PDF Form

Quick question for all. I know how to convert spreadsheets to PDF, as we utilize various versions of Adobe professional. Will be testing 8.0 shortly, however I have a simple question (I hope). In our organization, there are over 500 forms created; many of which are either Excel or Word format. A lot of these forms have formulas in the cells to perform mathematical functions. When the user converts the existing spreadsheet, to PDF, I want to make sure that they will still be able enter data into certain cells in the new PDF. My question is where is this enabled? Is there a setting in the original XLS file, or is it somewhere in the new PDF file?

Reply With Quote
  #2  
Old 11-01-2012
Member
 
Join Date: Jun 2011
Posts: 469
Re: How to convert a Microsoft Excel Worksheet as a PDF Form

Adobe Prof is able to create fill-able forms including preforming calculations from any source documents including spreadsheets. However each form will have to be tailored in Adobe to give you the fill-able form you want. The alternative is to (a) carry on using Excel .xls but use protection & validation to make the forms more robust or (b) use Excel forms function & VBA script create the forms you want.
Reply With Quote
  #3  
Old 11-01-2012
Member
 
Join Date: May 2011
Posts: 410
Re: How to convert a Microsoft Excel Worksheet as a PDF Form

Definitely cannot be done from the Excel end. Adobe Acrobat 7.0 has a plug-in that allows you to convert a PDF document to a fillable form. Note the word "convert" cannot be done in PDF alone. Do a 'net search for "fillable pdf form" and see what you get.
Reply With Quote
  #4  
Old 11-01-2012
Member
 
Join Date: Jul 2011
Posts: 614
Re: How to convert a Microsoft Excel Worksheet as a PDF Form

Good way to start is to first convert your existing excel form to pdf and then open the resulting pdf in Adobe Designer. From there you can tailor fields as your requirements dictate. A solution is a little tricky to print the file, scan it and pass the character recognition. Advantage: it works even if the software does not recognize the format tiff or pdf only jpg or other image format. Disadvantage: you have to have a good feeling to have a good recognition. In any case, it is necessary that the format "array" is supported.
Reply With Quote
  #5  
Old 11-01-2012
Member
 
Join Date: Aug 2011
Posts: 538
Re: How to convert a Microsoft Excel Worksheet as a PDF Form

Look for Universal Document Converter. This is the most complete solution for converting PDF documents. Download the tool and install it. Open the Excel file in Microsoft Excel and click File > Print. Set the Universal Document Converter as the printer and click on Properties button. In the configuration panel, click Load Settings. Use the Open dialog box to choose Worksheet to PDF.xml and click Open. Click OK in the Print dialog box of Microsoft Excel to start converting. When the PDF file is ready, will be saved in the My Documents \ UDC Output Files by default.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to convert a Microsoft Excel Worksheet as a PDF Form"
Thread Thread Starter Forum Replies Last Post
Replace Microsoft Excel 2010 Worksheet name via formula and link it to other Tur^turro Windows Software 1 13-01-2012 04:09 PM
How to stretch only one cell in Microsoft Excel Worksheet AbiaA MS Office Support 2 05-01-2012 05:04 PM
Clicking on Worksheet on multiple Worksheets in the single Excel file not allow viewing the worksheet in Microsoft Excel 2010 Dipanwita Windows Software 8 04-12-2011 10:24 AM
How to copy worksheet in Microsoft Excel 2010? Bharat89 Windows Software 3 09-01-2010 03:09 PM
Convert excel worksheet to graphic Indrani Windows Software 3 09-06-2009 01:45 AM


All times are GMT +5.5. The time now is 01:07 AM.