Is there a way to prevent Jira Cloud for Sheets from updating until I tell it to?

[Matthew DePasquale]

I have Jira Cloud for sheets working exactly the way I need it to using the =Jira() function except for one annoying issue. I can't make it stop updating data automatically. I've tried setting it to update manually and I've tried scheduling the update to happen once per month but whatever I do it still seems to update whenever it feels like it. I've even tried disabling the function after the import is done but then when it tries to refresh on its own my data is replaced with an error telling me that I have to enable the function. This is extremely frustrating because the data changes at random intervals and I can't make it stop. I want to import data once and then have it remain static until I'm ready to refresh it. Having the import refresh before I'm done analyzing the data is not only maddening it also makes what I'm trying to accomplish impossible. Any thoughts?

[Chris Buzon]

I'm not sure why it's automatically updating, but you might instead try to use the extensions -> Google sheets link instead of the =jira() function.  I have a number of sheets set up using the plugin and they don't update unless I re-fetch the issues using the same interface.

I don't use the function directly in a cell, but I also don't really know if it's supposed to work that way.  I suspect the function runs whenever you open the doc because the functions are 'live' (meaning they run whenever the sheet refreshes, instead of using the scheduling feature in the other interface).