Pro Tip 5

Getting timeout errors in Smart View?  Tired of the screen flickering when retrieving data.  Built into Smart View are optimizations that could help. 

From Smart View in Excel go to Smart View-> Help-> Health Check.

Health Check provides a menu with recommended settings.  Try them out and see if it helps with your Smart View performance issues!