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 formula to a text format, it saves them, but sometimes it is not always the case. Has anyone else had this issue and what is the work around?
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.
this works except on some files and some pcs the file takes sooo long to save, gets hung up and then some do not save as we expected
