Excel SAS Addin Refresh duplicating columns off to the right of input data

[cbrotz]

We have a large Excel spreadsheet that pulls SAS data through the SAS Addin.  In various files, we are finding duplicated columns of data off to the right of the main data in the worksheet after a refresh.  This is causing issues with formulas and it sees this as a duplicate and we are getting reference errors....Any suggestions on how to fix would be much appreciated.

[cbrotz]

So as a reply to my own post....it appears that the SAS Addin is now pulling in a column A with a counter for some of my datasets.  The counter is not part of the data, and I do not see an option to add this.  In order for all the data to line up, I added a column A as a blank to the old data sets and now I am not getting that duplicate column in my spreadsheet....at least for now.