Unable to Refresh AFO Reports 
After followed the below steps user are able to refresh the AFO reports with out any issue. 
 
Open your Analysis for Office 
Go to file > analysis > customize analysis > technical configuration 
Search for ForceRefreshConnectionInfo to true (check the box) 
Restart your Analysis for Office and reopen the workbook 
 
 Create a new PFB entry in SAP logon pad 