Frequently asked questions

Most common questions about Supermetrics Functions

How do I make the results span several cells? When I enter a function, I get a value to just one cell.
With the Supermetrics function (in older versions called "getData"), you can fetch large data sets with a single formula using the 'dimension...
Mon, 13 Nov, 2017 at 2:58 PM
How can I add a button that updates all the functions I've placed?
If you set calculation to manual in Excel's settings Formulas tab, you can update the functions by pressing F9, or by creating a button that does the u...
Mon, 13 Nov, 2017 at 3:00 PM
How do I get the function to return more rows/columns?
You can expand the range covered by an existing array formula by following these steps: Select the upmost left cell of the current array Starting from th...
Mon, 20 Mar, 2017 at 3:48 PM
How do I use the functions when connecting via a proxy server?
You can either disable the proxy server or modify the function VBA code to work with it. The easiest way is to disable the proxy from Windows Control Panel:...
Mon, 20 Mar, 2017 at 3:50 PM
How can I use the functions in an existing workbook I have?
If instead of using the provided template file you want build on an existing workbook of yours, you need to follow these steps to embed the functions into t...
Wed, 16 Aug, 2017 at 8:52 AM
How do I upgrade to a newer version of the functions?
Copy the code from the latest version of the template files to your existing workbooks, overwriting the previous code in those workbooks. For instructions o...
Mon, 13 Nov, 2017 at 3:07 PM