Hi all,
I am outputting data as an Excel file to SharePoint document library as part of any Analytic App. I dynamically create the file name and the sheet names in formulas, then use those in the SP output config AND I deselect the 2 options to have file name and sheet name in output.
However, when I run it the workbook name appears in the output but the sheet name does not.
Can't not figure out why this is occuring or anyway to fix it.
No errors or warnings in the process either, so it is running successfully to completion.
Anybody experienced this and have a solution?
Thanks
