Save offline copy in excel addin

[cindybowen]

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? 

[db_pdx]

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.

[cindybowen]

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