Refreshing Hidden Sheets

[Gary K]

Im creating a dashboard for a customer.
To do this I am pulling different information from different queries into one main sheet.

This main sheet also has a place to put the start and end date.
In querystorage I reference this location on the main sheet.

In the main sheet I also created a button with a Macro "refreshDataOnAllSheets"

Problem is that if the Query sheets are hidden, they dont get refreshed.

I dont want the query sheets to be shown since it just clutters up the xls file with tabs
and will confuse the customer.

How can I refresh the query sheets when they are hidden.
 

[Mikael Thuneberg]

At the moment, it's not possible to refresh hidden sheets. But we can change this in the next update.

 

--
You received this message because you are subscribed to the Google Groups "AutomateAnalytics" group.
To view this discussion on the web visit https://groups.google.com/d/msg/automateanalytics/-/N2ijRxU004AJ.
To post to this group, send email to automate...@googlegroups.com.
To unsubscribe from this group, send email to automateanalyt...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/automateanalytics?hl=en.

[Gary K]

That would be a great addition.

Thanks!

On Tuesday, May 22, 2012 3:39:21 AM UTC-4, Mikael Thuneberg wrote:

At the moment, it's not possible to refresh hidden sheets. But we can change this in the next update.

On 21 May 2012 20:58,

Im creating a dashboard for a customer.

To do this I am pulling different information from different queries into one main sheet.

This main sheet also has a place to put the start and end date.
In querystorage I reference this location on the main sheet.

In the main sheet I also created a button with a Macro "refreshDataOnAllSheets"

Problem is that if the Query sheets are hidden, they dont get refreshed.

I dont want the query sheets to be shown since it just clutters up the xls file with tabs
and will confuse the customer.

How can I refresh the query sheets when they are hidden.

 

--
You received this message because you are subscribed to the Google Groups "AutomateAnalytics" group.
To view this discussion on the web visit https://groups.google.com/d/msg/automateanalytics/-/N2ijRxU004AJ.

To post to this group, send email to automateanalytics@googlegroups.com.
To unsubscribe from this group, send email to automateanalytics+unsubscribe@googlegroups.com.

[Mikael Thuneberg]

Just released version 1.623: pushing the "Refresh all reports" button now refreshes hidden sheets too.

[Gary K]

Great!

[Daniel Chen]

Hi Gary,

Are you using the Google Docs version of Supermetrics?  If so, I was wondering if you would mind sharing your script or if I could ask you some questions about how you were able to write a macro/button that refreshes queries. I would like to use our queries in a dashboard for a client but I cannot figure out how to allow users to refresh queries from their end within the dashboard.

Thanks,

Dan

[Gary K]

Hi Dan,

No, I am using the Excel version. Basically, as noted above, they created a Macro called refreshDataOnAllSheets. So I basically created a button and attached the Macro to that button.

Thanks,

Gary

[Mikael Thuneberg]

For the Google Docs version, the clients can refresh the queries if they also install the Supermetrics add-on and click Refresh from either the Add-ons menu or the sidebar. Once Google lets us, we will also add the option so schedule an automatic refreshing (we need Google to move forward with this first: https://code.google.com/p/google-apps-script-issues/issues/detail?id=3858)

--
You received this message because you are subscribed to the Google Groups "Supermetrics" group.
To unsubscribe from this group and stop receiving emails from it, send an email to automateanalyt...@googlegroups.com.
Visit this group at http://groups.google.com/group/automateanalytics.

To view this discussion on the web visit https://groups.google.com/d/msgid/automateanalytics/7820b961-4329-4b6f-b7b8-13e016350365%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.