Open Norton Personal Firewall or Internet Security. You should see a screen similar to this. Next Select "Norton Personal Firewall" from the list on left and look for "status and settings." Select "personal firewall" and click the "configure" button on the right.
This screen opens. Select the "Programs" tab..
In the programs list find Excel. Set Excel® to "Automatic" or"Permit All". If you still have problems on "Automatic," you may want to change it to "Permit All."
Open McAfee Personal Firewall or Internet Security. Select "Personal Firewall Plus" from the left column.
Select "View the Internet Applications List." Look through the list for Excel® and set it to "Allow Full Access" either through right clicking or with the option on the lower right hand side.