+ Reply to Thread
Results 1 to 2 of 2

Volatile Functions on Google Sheet.

  1. #1
    Registered User
    Join Date
    04-11-2017
    Location
    uk
    MS-Off Ver
    mac 2016
    Posts
    8

    Volatile Functions on Google Sheet.

    Hi, this may be a stupid question so please bare with me. On google sheet, I have created a spreadsheet that make use of the indirect function for several hundred cells, and the calculation seems to be be instant but once i download it and open it in excel, the message "calculating: (8processors(s))" keeps appearing every time i edit a cell. I have found the reason behind this is because indirect is a volatile function and it causes excel to re-calculate all the formulas whenever a cell is changed, but why doesn't this happen to google sheet?

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Volatile Functions on Google Sheet.

    This does not answer your specific question but here is an excellent article from Chandoo which lists volatile functions, explains how Excel handles them, gives some suggestions as to how they may be avoided etc
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Replacing offset with non-volatile functions
    By beth6891 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-19-2016, 10:49 AM
  2. [SOLVED] what are volatile functions
    By ammartino44 in forum Excel General
    Replies: 3
    Last Post: 09-05-2015, 04:03 AM
  3. Replies: 4
    Last Post: 06-19-2015, 07:27 AM
  4. Volatile Functions causing issues
    By penfold1992 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-21-2014, 10:40 AM
  5. Replies: 3
    Last Post: 08-04-2014, 11:13 AM
  6. Volatile Functions needed for Roulette
    By Nickmsi in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-06-2013, 07:57 PM
  7. Volatile functions across books
    By jcarlosd in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-30-2008, 05:46 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1