saving excel document as pdf

[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?

 

[Roger Govier]

Hi

No, it can't be done, AFAIK

 

[Pete_UK]

I think you are asking too much.

Pete

 

[Dave Peterson]

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????).

 

[Salmon Egg]

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?

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

 

[Shane Devenshire]

Hi,

This feature is not provided by Microsoft Excel. One problem might be that
combo boxes can be created a number of way - form controls, Control Toolbox,
Data Validation lists.

There appear to be 3rd party add-ins that do this:

http://wareseeker.com/Business-Finance/cenopdf-3.1.35.zip/7ccabe7b8