saving excel document as pdf

  • Thread starter Thread starter minimus
  • Start date Start date
M

minimus

Is it possible to save an excel sheet in pdf format while keeping drop down
menus workable on the pdf file?
I mean suppose you have a drop down menu in an excel sheet where you can
choose numbers. Is it possible to save this file as a pdf file while
allowing the drop down menus still work in the pdf file? Or am I asking too
much?
 
I don't know. But I would expect it to depend on what program you use to create
that .pdf file.

There are PDF's that allow you to edit fields, use checkboxes, optionbuttons.
I'm not sure I've seen one that supported comboboxes, though.

You may want to ask in a forum dedicated to creating PDF's (maybe an adobe
forum????).
 
minimus said:
Is it possible to save an excel sheet in pdf format while keeping drop down
menus workable on the pdf file?
I mean suppose you have a drop down menu in an excel sheet where you can
choose numbers. Is it possible to save this file as a pdf file while
allowing the drop down menus still work in the pdf file? Or am I asking too
much?
Click to expand...

From the information theory point of view, the question should be is: Is
sufficient information in saved PDF to allow the original Excel
spreadsheet to be reconstructed?

If the answer is no, than you are out of luck. You might recover
something that looks like a spreadsheet, but with less information in it
than is in the original. That may be good enough, but remember Murphy's
Law.

If the answer is yes, than it should be possible to write code to do
that. That is, it should be possible to code an application to convert
your PDF file to an functioning Excel spreadsheet. That leads to three
possibilities.

0. Forget about it.

1. Convince Microsoft to add that functionality to Excel.

2. Code it for yourself if you can.

3. Get it from a third party. If something like that does not exist
already, be prepared to pay through the nose.

Bill
 
Back
Top