It doesn't make any sense. I can do it in Excel 2010 on Windows, but not Excel 2011 on OS X.
Workbook I used: http://cl.ly/Ewfe
I made a bash-script doing this on OS X in case any of you would like to do this:
You use it like this: