# Unable to Schedule Refresh in Google Sheets

This article will address the following error:

Unable to schedule refresh in Google Sheets. Error shown is "Exception: Bad Value."

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/error-bad-value-unable-to-schedule-refresh-in-google-sheets-1.png)

## Cause

Google Sheets requires you to set a Time Zone. Additionally, you must be a member of the report's hub in order to schedule a refresh via the Sheets data connector sidebar.

## Solution

Go to **File > Settings**. Choose the appropriate time zone and click **Save Settings**. Then schedule the refresh.

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/error-bad-value-unable-to-schedule-refresh-in-google-sheets-2.png)
