Skip to main content
cindybowen
Member
Jan 4, 2024 4:57 PM UTC

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 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? 

2 replies

db_pdx
Contributor
Jan 4, 2024 6:16 PM UTC

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.

 

cindybowenAuthor
Member
Feb 9, 2024 2:26 PM UTC

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

Terms & ConditionsAccessibility statement