Save offline copy in excel addin
We have files that utitlize vlookups or sumif formulas when we save an offline copy the formulas do not work after. I have found many times that if I change the value I am referring to in the formul...
Forum Discussion
Hi cindy: two things to check, the OneStream setting that controls whether data in QuickViews is retained and then standard Excel automatic calculation setting.
OneStream Setting:
OneStream (ribbon) > Preferences > General > Invalidate Old Data When Workbook is Opened > Set to 'False'
Excel Setting:
File > Options > Formulas > Calculation Options > Workbook Calculation > Set to 'Automatic'
Hopefully one of those fixes your issue. Let us know.