Link to home
Start Free TrialLog in
Avatar of hifive007
hifive007Flag for Canada

asked on

Excel Viewer vs Drop Down List

We are trying to use Excel Viewer to open an .xlsx file with a data validation drop down list and the drop down list doesn't work.

Is it a limitition of the Excel Viewer or it supossed to work?

Thanks,
ASKER CERTIFIED SOLUTION
Avatar of Edward Pamias
Edward Pamias
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hifive007

ASKER

Ok bad news and good to know...
Do you have any link with the reference because I don't find Nothing telling if it's supported or not?

Thanks!
I had the link and now I have to find it again, I did not believe what I read so I installed the viewer and tested. No luck for me on this end. Let me see if I can find it again.

If you think about it, it should not work because it's only allowing you to view a file, the functionality won't be there with a viewer.
And here is what I found on another site...

Limitations of Excel Viewer

Since this tool is provided for free, some features that are found in the standard version of Excel are not available. For instance, you cannot edit any of the data within the Excel workbook. There is no function to save the workbook or to create a new workbook. The primary purpose of Excel Viewer 2007 is to open Excel workbooks for viewing and printing, and that is exactly what the software does.

Third-party alternatives do exist, however, that allow you to open and edit Excel files, along with many other Microsoft Office files. OpenOffice.org, Google Docs, and Zoho.com are a few examples of programs and websites that allow you to edit common Office files. While these programs are useful, they may not display Excel files (especially Excel 2007) in exactly the same format that Excel does. For this reason, Excel Viewer 2007 is superior if you only need to view files
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial