Have you ever had your “Refresh from Excel” option go missing when working with a Dynamic worksheet or Pivot Table?
You were smart. You exported your view as a Dynamics Pivot Table or Dynamics Worksheet so all you had to do is refresh it when you wanted updated data. BUT, from reason you go into your spreadsheet and the refresh button is gone. Where did it go and how can you get it back?!?