Google Docs - how to refresh?

5,803 views
Skip to first unread message

m...@catbirdseat.de

unread,
Jul 19, 2013, 8:19:29 AM7/19/13
to automate...@googlegroups.com
Hi,

what''s the mechanic of Google Docs used with Automate Analytics? If I make any change to the active worksheets, all cells are getting calculated, except the one with the formula =getdata.

Does the "Addin/Script" refresh by changes made? Is it possible to let the script periodically refresh? And would it be theoretically possible to get the worksheet refreshed even if no user has open it?

Thanks in advance!

Martin

Mikael Thuneberg

unread,
Jul 23, 2013, 3:10:09 AM7/23/13
to automate...@googlegroups.com
The functions refresh when any of the parameter values change. To force a refresh when no parameters have changed, you can open the script editor, and press save in the editor that opens. That saves the script and forces the spreadsheet to recalculate all function instances.



--
You received this message because you are subscribed to the Google Groups "AutomateAnalytics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

Reply all
Reply to author
Forward
0 new messages