You can put all bar the index into the one set of options and flag the top set in your code above ie: options (Sheet_Name = 'By Region' sheet_interval='none' embedded_titles='yes' embedded_footnotes='yes') The index you are trying to use only works on worksheets in the ExcelXP tagset. If you want to do this instead ie one output per worksheet then the index can go in the options above, it doesn't need a separate one.
... View more