Excel Add-In Only pull when needed

Right now, if I pull historical data for the previous month (say, raw values). Then I go to a new cell and type in '=1+1'. When I hit enter, Canary will repull the previous month data. If I've lost connection to Canary, or the authentication has timed out, Excel will hang up for a minute until I got one of a variety of vague errors. Like: 

Only after I hit OK on the error will it tell me that 1+1 is equal to 2. This happens any time a cell in Excel changes.

I could globally disable calculations, but that's not a valid solution. I could copy/paste as values after I pull the data, but that's not a good solution.

We need to figure out a way to have Excel Add-In only pull data when it needs to. E.g., an input parameter is changed.

There are other, similar, Add-Ins out there that do not query data if you calculate 1+1 in an unrelated cell. So theoretically it's possible!

Is it as simple as setting https://learn.microsoft.com/en-us/office/vba/api/excel.application.volatile to false?!