That is interesting.  Slightly different from what I am experiencing where the actual source data does not change.  the save date is not updated.  nothing.  just SAS thinking it wrote out correctly.  And the real problem is that for me it is not consistent.  Sometimes it will work and other times it will not.  I am also outputting data to a raw named range that is referenced by the pivot table (that is important if you are not building your pivot table that way I would suggest changing).    So far I am still stuck with saving the SAS dataset that I am writing to Excel.  Checking Excel to see if it actually updated. And then building an abort process if it did not update. Not a fix but it does prevent me from sending bad data to users.  ... View more