Skip to main content
C
cindybowen
January 4, 2024

Save offline copy in excel addin

  • January 4, 2024
  • 1 reply
  • 0 views

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? 

1 reply

D
db_pdx
January 4, 2024

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.

 

C
cindybowenAuthor
February 9, 2024

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