"ADFI-05566 Unable to retrieve values for the last binding "OrgIdlist", or for one or more of its dependent lists"

Error

"ADFI-05566 Unable to retrieve values for the last binding "OrgIdlist", or for one or more of its dependent lists"

Details of the error:

The remote server returned an error: (500) Internal Server Error.

~~~~~~~~~~
WebException: The remote server returned an error: (500) Internal Server Error.
Source: System

Solution:

Set the DEFAULT_ORG_ID profile for the user to one of the accessible Business Units

Go to Setup and Maintenance
Search for the task "Manage Administrator Profile Values"
Go to Task
Search for Profile option code "DEFAULT_ORG_ID"
Click on + icon on last table
Set the profile level as User
Set the user name in User Name
Set the Business Unite name in Profile Value and save and close

If you are using Internet Explorer Version 10 which is not certified with Fusion Applications as of April 2014, you will need to do the step above AND:

Open Excel
File > Options > Trust Center
click Trust Center Settings button
Select Protected View in left panel
Un-check the first two check boxes.
Click OK (twice) to close the dialogs.
Close Excel.

If you would like to keep Protected View, use the following workaround:
When prompted if you would like to save or open excel. Choose save. And then later open excel file from saved location.

Also check:

Open Excel and > Excel Options > Trust Center.
> Trust Center Settings.
> Macro Settings.
> Select the Trust access to the VBA project object model check box.
> Click OK to close the Excel Options dialog box.