Why are HsGetValue formulas in one workbook refreshing when submitting a form in another workbook
Summary:
I have a user who has a fairly complex workbook with many HsGetValue formulas in it. They refresh it once a day and keep it open to refer to throughout the day. However, when that workbook is open, and they are in another workbook on a form and submit on that form, the HsGetValue formulas refresh, causing the whole submission to take much longer than it should because it's doing the refreshes in the other workbook.
Content (please ensure you mask any confidential information):
Some things I've noticed. I tried having an HsGetValue report I have open and submitting on a form at the same time, but it didn’t cause the HsGet to refresh. My own HsGetValue report isn't as complex. I am able to replicate the behavior with the user's workbook though. In any case, I don't think that a submit in one workbook should be doing anything in another. If the user changes their calculation option to manual, that keeps it from refreshing, but it's not a good long term solution. Has anyone seen this or know what might cause it? I'll