When saving the report in an Excel format, is there a way to specify a sheet name in an existing workbook? If so, does it leave the contents of the other sheets intact?
There is currently now way to accomplish that as the export engine overwrites any file you are exporting to. Here is what I'd typically do as an alternative:
- Set up Logicity to export out to it's own Excel file.
- Create a second Excel file (or use an existing one) and reference the other spreadsheet.
This way the Logicity Excel file will get overwritten with new data periodically and your spreadsheet will automatically get the latest data.
Make sense?
Take care,
Adam
The administrator has disabled public write access.