How to refresh ...

Overview

Refresh Methods...

Refresh Examples

Googlesheets

Excel

Limitations

## How to refresh data in Cryptosheets

### Overview
There are multiple ways to refresh data in both <linkify text="Excel"></linkify>
& <linkify text="Googlesheets"></linkify>. Some methods may be limited by your <linkify text="subscription"></linkify> which you can see on the <linkify text="subscription"></linkify> page. This page explores various methods & examples for both environments.

![IMG](https://res.cloudinary.com/cryptosheets/image/upload/v1571966039/cryptosheets-docs/excel/functions/exrate-hp-9.gif)


<iframe
  style={{ maxWidth: "570px" }}
  width="570"
  height="350"
  src="https://www.youtube.com/embed/2xYvhc-3KA8"
  frameborder="0"
  allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture"
  allowfullscreen
></iframe>


### Refresh Methods (from your spreadsheet)

1. Refresh the entire workbook
2. Refresh a specific cell or formula
 
### Refresh Methods (from the source)

1. Streaming refresh (ie [`CS.EXRATE`](https://docs.cryptosheets.com/functions/streaming))
2. Auto invocating refresh (ie [`CS.TIME`](https://docs.cryptosheets.com/functions/time))


### Refresh Methods (using templates)

[![img](https://miro.medium.com/max/1000/1*QRnBQV0MrPgGUevPotqFcw.gif)](https://medium.com/cryptosheets/how-to-build-a-real-time-streaming-cryptocurrency-dashboard-in-excel-in-5-minutes-60dca67a6627)







### Refresh Examples

> TIP: [Use Google](https://www.google.com/search?q=how+do+i+refresh+data+in+cryptosheets) to help search for Cryptosheets data refresh examples by adding a **`"?"`** to your question

**Example**: [`"How do I refresh data in Cryptosheets?"`](https://www.google.com/search?q=how+do+i+refresh+data+in+cryptosheets)

[![IMG](https://paradigmas.blob.core.windows.net/paradigmas-content/sharex/cryptosheets-docs_google_refreshing-data-search-questions-from-google.png)](https://www.google.com/search?q=how+do+i+refresh+data+in+cryptosheets)

#### Googlesheets

1. Using your keyboard 

   Select any cell with a formula then **`press F2 + enter`**

2. [Using a checkbox](https://www.youtube.com/watch?v=2xYvhc-3KA8&list=PLBg8GR5ao-azCwkh769O7WUMPOKdleKNH&index=14&t=0s)
3. Using [Googlesheets built in spreadsheet settings](https://intercom.help/cryptosheets/en/articles/4456485-how-to-configure-auto-refresh-for-googlesheets)
4. [Using =GOOGLEFINANCE()](https://intercom.help/cryptosheets/en/articles/3972081-how-to-automatically-refresh-cryptosheets-custom-functions-data-in-excel-googlesheets-using-cs-time)

   <inline-code functionvalue='=CSPRICE("BTC","USD",,"Coinbase","ask",GOOGLEFINANCE("CURRENCY:USDEUR"))'>=CSPRICE("BTC","USD",,"Coinbase","ask",GOOGLEFINANCE("CURRENCY:USDEUR"))</inline-code>

   ![img](https://downloads.intercomcdn.com/i/o/246206395/2b52e9967491a70de99f8e18/image.png)

   ![img](https://downloads.intercomcdn.com/i/o/207124346/54bb53399eed1955a7a3c800/image.png)



#### Excel

1. Using your keyboard

   Select any cell with a formula then **`press F2 + enter`**

2. [Using a checkbox](https://www.youtube.com/watch?v=2xYvhc-3KA8&list=PLBg8GR5ao-azCwkh769O7WUMPOKdleKNH&index=14&t=0s)
3. Using [`CS.TIME`](https://docs.cryptosheets.com/functions/time)

   ![img](https://downloads.intercomcdn.com/i/o/207137503/62ff7ae9a5a28fe1697ca1ad/cryptosheets-docs_excel_functions_csprice-refresh-example%5B1%5D.png)

4. Using [`CS.EXRATE`](https://docs.cryptosheets.com/functions/streaming)


### Limitations

> **TIP**: Remember that just because you are refreshing a formula or API call in your spreadsheet doesn't necessarily mean the actual underlying data (from the source) is being refreshed at the same time or frequency

#### Googlesheets
1. Does not support real time refresh or streaming


Learn several options for how to automatically refresh your Cryptosheets data in Excel and Google Sheets

Data Refresh