/docs/community?hl=en
/docs/community?hl=en
5/10/10
Original Poster
dcummiskey

ImportData how often does spreadsheet update?



I'm using Firefox and the newer version of Google Spreadsheets.Using ImportData, how often does this refresh? Or do we have to hit shift refresh to get the data to update?








2010-05-10
I'm using Firefox and the newer version of Google Spreadsheets.Using ImportData, how often does this refresh? Or do we have to hit shift refresh to get the data to update? Currently, the csv we use updates automatically every 20 minutes.
Community content may not be verified or up-to-date. Learn more.
Recommended Answer
Was this answer helpful?
How can we improve it?
All Replies (2)
ahab
5/10/10
ahab
About once every hour. The data is only refreshed on the server that buffers the data, so refreshing your spreadsheet won't help.

For a workaround method to overcome the delay see [1]

 
5/10/10
Original Poster
dcummiskey
&"?workaround="&INT(NOW()*1E3)&REPT(GoogleFinance("GOOG");0) worked. thanks.
 
This question is locked and replying has been disabled. Still have questions? Ask the Help Community.

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

 
Expert - Google Employee — Googler guides and community managers
 
Expert - Community Specialist — Google partners who share their expertise
 
Expert - Gold — Trusted members who are knowledgeable and active contributors
 
Expert - Platinum — Seasoned members who contribute beyond providing help through mentoring, creating content, and more
 
Expert - Alumni — Past members who are no longer active, but were previously recognized for their helpfulness
 
Expert - Silver — New members who are developing their product knowledge
Community content may not be verified or up-to-date. Learn more.

Levels

Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:

  • Post an answer.
  • Having your answer selected as the best answer.
  • Having your post rated as helpful.
  • Vote up a post.
  • Correctly mark a topic or post as abuse.

Having a post marked and removed as abuse will slow a user's advance in levels.

View profile in forum?

To view this member's profile, you need to leave the current Help page.

Report abuse in forum?

This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.

Reply in forum?

This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.