Monday, November 2, 2015

SmartView is gone from Excel!!

I get this a lot from my clients, "SmartView is missing from Excel, please help!!"

Actually, its not missing, its just disabled.  Usually, if  Excel crashes for some reason (like a long retrieve or run out of memory), Excel will blame SmartView and disable the add-in.  Have no fear, you can enable SmartView very easily.

In Excel 2010 (works similarly for other version of Excel), follow these steps:



Go to "File", then "Options"






















Within options, choose "Add-Ins" on the left hand side






















On the bottom you will see a drop down box next to "Manage", choose "Disabled Items", then click "Go"











A dialogue box will appear, click on SmartView, then click the "Enable" button.

You may need to restart Excel for the changes to take place


No comments: