• Launch Excel and select the “PowerExcel” tab from the Navigation Ribbon at the top of your screen

  • From the PowerExcel panel, click on the “Connections” icon from the PowerExcel Connections Section within the navigation ribbon.

 

  • In the Connections menu that appears on your screen, click “New” to create a new connection.

 

 

  • Type the Name that you wish the connection to be called.
  • Then in the URL window type http:\\localhost:4387 for a locally loaded Database or http:\\ then the IP address of the server where the Database is located then :4387. If the IP was 123.45.67.98 it would look like this http:\\123.45.67.89:4387
  • From the dropdown “Database” menu, select your database name and click “OK”.
  • You have successfully created a PowerExcel Connection and can now proceed to create a slice.