Forum Discussion

Kaiba's avatar
Kaiba
New Contributor
10 months ago

Any Setting to Require a Refresh of OneStream Excel Add-in Data When Workbook is Opened?

I understand that OS users are able set their own preferences for whether or not Excel Add-in data refreshes upon opening a workbook, however I would like to know if there is an option for the "autho...
Excel Add In
  • JackLacava's avatar
    JackLacava
    10 months ago

    I don't think there is such a feature, but I wouldn't expect any data to be in the spreadsheet. At least with xfget, cells should still be formulas (as long as you didn't convert them), so when a user doesn't have the add-in or cannot log on, the formulas shouldn't be able to return any numbers. Things might be different with QuickViews - if you test and the behaviour there is different, you might want to get in touch with Support and describe it as a security issue.

JackLacava's avatar
JackLacava
Honored Contributor
10 months ago

I don't think there is such a feature, but I wouldn't expect any data to be in the spreadsheet. At least with xfget, cells should still be formulas (as long as you didn't convert them), so when a user doesn't have the add-in or cannot log on, the formulas shouldn't be able to return any numbers. Things might be different with QuickViews - if you test and the behaviour there is different, you might want to get in touch with Support and describe it as a security issue.