Dynamic Worksheet – Specified SQL server not found

I was trying to export a dynamic excel sheet from CRM and received the following error on my Windows 7 laptop.

 

Specified SQL server not found

After some tinkering, found out I needed to allow Excel through the Windows Firewall.  Follow the steps below:

Open up the Control Panel

Control Panel

Select System and Security and Windows Firewall

Windows Firewall

Select Allow a program or feature through Windows Firewall

Select Change settings

Browse to the Excel.exe

Allow Excel through Windows Firewall

Advertisement