One important thing to remember when you call your SharePoint Powerpivot Gallery. Use the computername to connect, so no IP adress or localhost in your IE. No workbooks will show up when you don’t use the computername. When you did make a single box install but still want to access the SharePoint from a remote machine just add the ipadress and computername to your host file, and log in with the sharepoint credentials.