Could you provide the refresh failure error message?
Is the data source name in the Excel report the same as that which is listed in the Gateway. It has to be exactly the same. Perhaps compare the data source details of the report that is working with the one that is failing.
This GuyInACube video provides good info on fault finding gateway connection issues.