Skip to main content
B
BobNelson
February 11, 2026
Question

Excel add-in: Save offline version not working

  • February 11, 2026
  • 3 replies
  • 0 views

I have a client who is trying to save an offline version of some of their excel reports in order to share them with their auditors.

First they open the spreadsheet, refresh the workbook, then select the "Save Offline Copy" feature from the OneStream ribbon bar.

Second, they close the original spreadsheet, then attempt to open the "offline" version.  What appears is a series of #VALUE! where there should have been offline data.



Has anyone else out there encountered this?  Is it a known bug?  Is there any type of work-around?  The client does not want to use excel's copy-paste value feature because there are excel (non-OneStream) formulas such as "SUM" that they want to preserve.

Any ideas, suggestions, or information would be much appreciated.

Thank you,

3 replies

J
JJones
February 12, 2026

Bob,

What is the "Retain All Formatting when Saving Offline" option set to in the OneStream Add-in Preferences?  

 

M
michaelkeung
March 22, 2026

what version you are using?
They had problem in v9 and they fixed it in v9.2

S
smarshall2
March 23, 2026

If you haven't moved to 9.2, we found that if the user opens the file in the Spreadsheet function, Saving Off-line works.  We found this issue with our larger files, as a bonus, when we used the Spreadsheet function, they also retrieved quicker. 

Terms & ConditionsAccessibility statement