I had the same problem and it started after I checked the option "Analysis Toolpak-VBA
" in Add-Ins.

Path in Excel = Tools - Add-Ins

Make sure the option "Analysis Toolpak - VBA" is unchecked. Hope this solves your problem.