When configuring the Jet Excel add-in to work with Dynamics NAV 2013's Web Service, it can be helpful to test the setup to make sure the Web Service is working as expected.
In this Microsoft article, Microsoft provides an easy test.
Below is an excerpt from that article.
Publishing a Page as a Web Service
You publish a web service using the Dynamics NAV RoleTailored client.
To publish a page as a web service:
Open the Microsoft Dynamics NAV Windows client, and then connect to the CRONUS International Ltd. company.
In the Search box, enter Web Services, and then press Enter.
In the Web Services page, choose New.
In the Object Type column, select Page, and then enter 21 in the Object ID column and Customer in the Service Name column.
Mark the check box in the Published column.
Choose OK to close the New - Web Services page.
Verifying Web Services Availability
To verify availability of a Microsoft Dynamics NAV web service
Start Windows Internet Explorer.
In the Address field, enter an address of the following type:
The browser should now show the web service that you have published:
<contractRef xmlns="http://schemas.xmlsoap.org/disco/scl/" ref="http://localhost:7047/DynamicsNAV70/WS/CRONUS International Ltd/Page/Customer"/>