I'm dynamically generating an XML spreadsheet in ASP.NET and setting
the content disposition to attachment so the user will be able to open
or save the document. If they select Open, "[1]" is getting appended
to the filename, which is breaking the ConsolidationReference FileName
setting in my pivot table. Is there a way to get a
ConsolidationReference to default to the current workbook?

Thanks in advance!

Paul