In a previous post HERE I included a link to an Excel file with a lookup that allows users to select from among 400+ Oregon places and counties to find renter cost burden counts and percentages from ACS 2006-2010.
As this workbook contained multiple formulas and looks, and multiple worksheets, I thought this would be a good file to test embedding into a blog post after I separated one worksheet into two to make them more visible when posted on a web page.
- Embed codes for Excel cloud posts to web pages/blogs do not support data validation, so pull downs from a list of valid names cannot be used. For this workbook this means that users can still type in the name of an area in far left hand column, but unless it matches perfectly the area name found in the lookup table, erroneous data will be returned. [You can check an area name in the data worksheet tab if you need to].
- If you open or download the Excel file from a web posted version (file name has suffix of "editable") data validation has been removed). The Excel file I first uploaded to my public Excel folder on my MS Skydrive HERE continues to have data validation but you must use the "Open in Excel" tab at top left after this link initially opens the file in your browser (with "unsupported features").
- Excel cloud posts to web pages do support multiple worksheets, via the tabs at the bottom of the workbook.
- Excel cloud posts to web pages do appear to support sophisticated lookup formulas from large data tables.
As before, feedback on your experience viewing and downloading would be appreciated.