In reply to Jørgen Boysen.

Jørgen,

Other than using LIBNAME XLSX to completely replace a sheet, I think the method you need to use involves some sort of post-processing on the Excel file. You can use SAS to generate a script (VB Script, PowerShell) that automates Excel to place the value exactly where you need it, and then use X or SYSTASK to run that script as the last part of your SAS job. All of this, of course, requires that your SAS output (including the script) are on the same machine where Excel is.

When that's not the case -- when running through EG -- you could use SAS to create the script file, use the Copy Files task to copy the script file to the local PC, then use the Command Prompt task to execute. All of this can be captured in the process flow. The Copy Files task and the Command Prompt task are both available for download from this blog.