For some reports I need to insert a formatted disclaimer page in an Excel file and a second sheet with data. This data sheet is beging generated and the don’t want any formatting on it. In the screenshot below you see a demo of the situation. (Also included is the workflow….)
The workflow runs fine. But when opening the Excel file it will give you an error.
If you select Yes it will open Excel and all the worksheets are available, but No data on the Data sheet.
Whats happening, and how can I solve this…….
Solved! Go to Solution.
Try writing a single row of data in your data sheet with the render tool and then overwrite the sheet with the output data tool.
I posted something like this before for a similar problem, I'll dig it out and send it on