01-31-2017 08:06 PM - last edited on 02-02-2017 11:01 AM by AnnaBrown
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.
02-02-2017 10:11 AM - edited 02-02-2017 11:03 AM
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.