I have a workbook that is shared with my laptop and android, it has a Pivot Table & Chart.

When I open my workbook from android to refresh data.

I can't seem to click on the Refresh button Tab Pivot Table. My Workbook is not protected with a password. I wanted it to be Auto or Manual Refresh data when workbook is open from android.

Any help would be appreciated.