A new Sheet tab in Excel is copied from an existing tab that contains a Smart View query, but clicking Refresh does not refresh the data and the Smart View (Point of View) POV bar does not display. Which additional step is required to pull data in the new tab and change the POV?

• A. Disconnect from the Smart View connection, and relog in.
• B. Activate the Connection
• C. Close out of Excel, and relog in to Smart View
• D. Change one of the Row or Column dimension members and click Refresh.

Answer: (B)

In Smart View, data retrieval is tied to an active connection on each worksheet. When you copy a sheet that already has a Smart View query, the new tab doesn’t automatically establish a live connection, so Refresh won’t pull data and the POV bar won’t appear. Activating the connection on the new sheet makes it live again, which enables data retrieval and displays the Point of View (POV) bar. Once activated, you can set the POV and then refresh to load the data. The other options don’t establish the necessary link for that sheet, so they won’t cause the data to pull in.