Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting a spreadsheet into a "fillable" 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 spreadseet, 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? Thanks for any assistance, Nat |
#2
|
|||
|
|||
Answer: Converting a spreadsheet into a "fillable" PDF form
Hi Nat,
Great question! Yes, you can definitely convert your Excel spreadsheet into a fillable PDF form while still preserving the formulas in the cells. Here's how:
That's it! The ability to enter data into certain cells in the new PDF will be enabled by the fillable form fields you created in Acrobat. There's no need to enable anything in the original XLS file.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting a spreadsheet into a "fillable" PDF form
Adobe Prof is able to create fillable forms including preforming calcluations
from any source documents including spreadsheets. However each form will have to be tailored in Adobe to give you the fillable 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. -- Peter London, UK "Nat" wrote: 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 spreadseet, 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? Thanks for any assistance, Nat |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting a spreadsheet into a "fillable" PDF form
Nat
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. Try this link for starters. http://www.planetpdf.com/enterprise/... fillableform Gord Dibben MS Excel MVP On Sun, 4 Feb 2007 09:30:01 -0800, Nat wrote: 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 spreadseet, 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? Thanks for any assistance, Nat |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting a spreadsheet into a "fillable" 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. -- Best, -HB "Nat" wrote: 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 spreadseet, 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? Thanks for any assistance, Nat |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting a spreadsheet into a "fillable" PDF form
Thanks to all who replied. I will play around a bit in Adobe to see how to
pick and choose which cells are fillable. I will also do a search for fillable pdfs as Gord suggested. Nat "Brazil" wrote: 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. -- Best, -HB "Nat" wrote: 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 spreadseet, 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? Thanks for any assistance, Nat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using data form in large mailing list spreadsheet | Excel Discussion (Misc queries) | |||
Spreadsheet as form using Access for records | Excel Discussion (Misc queries) | |||
Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
Merge Excel data into specific form areas in a Word Doc | Excel Discussion (Misc queries) | |||
Auto refreshing and printing a form with data from each row of a spreadsheet | Excel Discussion (Misc queries) |