If you open a new excel file, does the Refresh button works? I suspect it is something specific to do with the spreadsheet that is causing the Refresh button to be greyed out. I'd suggest opening a case with SAS Tech Support.
I found a solution where the source was not selected because of this the button was gray
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.