Hey guys I have an excel spreadsheet linked up with smart view/Hyperion

If I make a button on my tab titled "Input key" I want to click this button and I want the button to refresh, I named the button "button1"

My hyperion connection is "ESSPRD2_MPSA_P_CorePlan" and its a private connection.

The tab I want to refresh is titled Revenue... any help anyone?