10-02-2017 07:27 PM
I have been trying to automate refreshing a pivot table from SAS and followed the previous suggestions from the link below :-
However I still get the DDE Error :-
ERROR: DDE session not ready.
FATAL: Unrecoverable I/O error detected in the execution of the DATA step program.
Aborted during the EXECUTION phase.
options noxwait noxsync;
filename cmds dde 'excel|system';
Here the Excel file is a 2003 file and I have debugged this code. I get the error with this code line ' put "[pivot.refresh()]"; '
10-02-2017 08:10 PM - edited 10-02-2017 08:11 PM
Is that the correct command for an XLS file? What's the command in the Microsoft 4.0 guide?
Also, is your pivot table starting in that cell?