I had reinstalled sforce and found the problem that it was looking at the old spot where sforce connector was located. It irked me that the fix for the problem was inadequate. Here's the steps that worked for me.
1. Open up excel 2. RIGHT click the area where the sforce connector button would usually lie. A dropdown menu should appear with the last option being "Customize" 3. Click on "Customize" 4. The Customize window should appear. Scroll down to the bottom until you see sforce Connector. 5. LEFT click to highlight the sforce Connector, and click delete. 6. When it asks if you are sure you want to delete it, click Yes. 7. Click Close 8. You are back to where you started. Click Tools 9. Click Add-Ins 10. Click browse and select the sforce_connect_for_.xla 11. It will say the file already appears, do you want to replace? Click yes.
Finally! If you don't see the sforce connector button, Right click the area where the sforce connect button would usually lie, and make sure there's a checkmark next to the sforce Connector in the drop down menu (where you saw Customize before)
I had reinstalled sforce and found the problem that it was looking at the old spot where sforce connector was located. It irked me that the fix for the problem was inadequate. Here's the steps that worked for me.
1. Open up excel 2. RIGHT click the area where the sforce connector button would usually lie. A dropdown menu should appear with the last option being "Customize" 3. Click on "Customize" 4. The Customize window should appear. Scroll down to the bottom until you see sforce Connector. 5. LEFT click to highlight the sforce Connector, and click delete. 6. When it asks if you are sure you want to delete it, click Yes. 7. Click Close 8. You are back to where you started. Click Tools 9. Click Add-Ins 10. Click browse and select the sforce_connect_for_.xla 11. It will say the file already appears, do you want to replace? Click yes.
Finally! If you don't see the sforce connector button, Right click the area where the sforce connect button would usually lie, and make sure there's a checkmark next to the sforce Connector in the drop down menu (where you saw Customize before)
