Hi!
In Sourcing queries you can add a workbook template to customise the format of the report when it is exported to Excel.
I have a scenario where this functionality works well in a version 5.1 system, but not so well in a version 7 system - on export to Excel the reformatted report fields are now all displayed as blank fields, and values only appear after you perform a 'Save As' manually in Excel.
The exact scenario is as follows:
1. An Excel workbook is initially created by exporting the query results to Excel.
2. A second worksheet is then added with a custom format and the data fields referenced from the the first sheet.
3. The first worksheet is then hidden, and the second one protected in Excel.
4. The workbook is then uploaded to Sourcing a a workbook template file attachment container, and assigned to the query Workbook template.
5. When the query is executed and the results exported to Excel, In 5.1 you see the reformatted report layout with data straight away, as you want. In version 7 you just see blank fields until you use 'Save As' from the Excel menu.
Any ideas why this is happening in the version 7 systems and possible work arounds?
Thanks for your help,
Stuart