Unable to Refresh AFO Reports 
After followed the following steps users are able to refresh the AFO reports locally .  
 
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 