/docs/community?hl=en
/docs/community?hl=en
8/5/09
Original Poster
ahalleck

Refresh and Recalculate -- Google Spreadsheet

Hi,

I am attempting to create a shared spreadsheet that does some calculations and tracking that are based on the current date.  I need to have those calculations automatically recalculated every time the document is viewed, without the user needing to enter any data.  I am aware that Google Spreadsheets used to recalculate every time they were reloaded (and thus, viewed) by a user... but this no longer seems to work.  Is there some way that I can turn this option back on?

Community content may not be verified or up-to-date. Learn more.
All Replies (7)
mahesh2000
9/21/09
mahesh2000
Select the cell and press Ctrl+R to get it to recalculate. this is a workaround. Ctrl+R actually copies the cell to the cell to its right, but as you've selected only one cell, it just recalculates instead. you'll have to do this for *all* cells that have a random function (rand or randbetween). this can get to be a nightmare, so the solution posted (see http://www.google.com/support/forum/p/Google+Docs/thread?tid=3cade1c62e906b6f&hl=en#all) says that you should have one random seed, such as rand(), and then connect all other random formulae to this cell that way, you can just update ONE cell, which recalculates them all.

here's the gist of it:

No, unless you connect all randbetweens with one fixed cell, e.g.
A1: =RAND()
A2: =RANDBETWEEN( 0 ; 1 ) +0*$A$1
A3: =RANDBETWEEN( 0 ; 1 ) +0*$A$1
A4: =RANDBETWEEN( 0 ; 1 ) +0*$A$1

Now you only have to select A1 and press Ctrl+R

Do you have these randbetweens in a block range, e.g. B2:H11 then you can use a formula like this
B2: =ARRAYFORMULA(RANDBETWEEN(0+0*ROW($A$2:$A$11);1+0*COLUMN($B$1:$H$1)))
You only have to refresh B2 using Ctrl+R to let the entire block recompute



Giantbean
11/13/09
Giantbean
This Used to be true for me but lately If I change one RANDBETWEEN it recalculates all the RANDBETWEEN cells on the Sheet. I don't want that to happen. So How do I get the sheet to function like it used to? I havent made any changes so it must be something in the way the Spreed sheet is written at the Google level.

Is their an alternative to RANDBETWEEN that works Like the old RANDBETWEEN worked a month or two ago?

I used to have code:
 =RANDBETWEEN(Cell1:Cell2) in cell3 then in cell4 I have code =RANDBETWEEN(Cell5:Cell6) If I changed Cell 1 or 2 It would only recalculate cell 3 and if I changed Cell 5 or 6 it would only recalculate cell 4 but now if I change cell 1,2,5 or 6 it recalculates cell 3 and 4 every time.

How do I fix this?

Ted J
5/14/14
Ted J
Hi all,
  In the newest version of Google Sheets you can see the recalculation options by going to File>Spreadsheet Settings.

Cheers,
Ted J
Markus Bryant
6/22/14
Markus Bryant
Ted, spreadsheet settings seems to only allow us to to set locale and time zone; do you know where recalculate settings are now?
Google user
6/24/14
Google user
The function in "spreadsheet settings" for refresh rate was there but is no longer showing. What happened? 
Ted J
7/2/14
Ted J
Hi all,
  This feature is only available in the newest version of Sheets.  Look for a green checkmark in the bottom right of your spreadsheet. If you see one then you can follow my instructions above to see information about recalculation.

Cheers,
Ted J
giladlavie
7/5/14
giladlavie
Hi all,

The recalculation settings in the new version of Sheets doe's not work on mobile devices.
For example when I open a sheet from my iPhone it's not recalculating every minute (although the settings say it is).

Can someone help me?

Thanks.

Were these replies helpful?
How can we improve them?
 
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.