Forum Discussion

kmd's avatar
kmd
Contributor
12 months ago

Excel "Save Offline Copy" hanging during Save

Hi all,

Has anyone else experienced the following issue with "Save Offline Copy" feature in excel?

If the user has "retain all formatting" set to TRUE in preferences, the file takes an unreasonably long time to save.  During my testing of the file (only 684 bytes in size), I waited over 10 minutes for save to complete and it never did so I had to kill Excel and relaunch every time.

If that retain formatting option is set to FALSE, the file saves immediately. Interestingly it also saves with all the formatting as well - except for any 'superscript' font settings.

Same behavior seen whether using Excel 32 or 64 bit.  

Same behavior seen whether saving to local folder or onedrive folder

This makes no sense.  Really all the save offline process should be doing is replacing all cells containing XF() functions, with the resulting values. Right?  And If I set retain formatting to FALSE, shouldn't it save without any formatting at all?  This setting doesn't seem to be working properly, or am I misunderstanding the purpose of this option?

Before I submit a ticket to OS, thought I should check here first and see if someone in the community has run into this problem as well or can explain to me what's happening here.  Thanks in advance for any ideas.

 

Excel Add In
  • Cosimo's avatar
    Cosimo
    Contributor II
    5 months ago

    Hey JackLacava,

    Any chance someone from product can explain what exactly is happening when we click on Save Offline Copy? My users are struggling with this feature with larger workbooks and especially those with cells linked to another workbook. As kmd stated, you would think that the offline copy would simply replace the values from XF functions as a paste value but it seems to be more complicated than this.

    • JackLacava's avatar
      JackLacava
      Honored Contributor
      5 months ago

      I can only tell you that this specific area (i.e. retaining formatting) will see a lot of improvements in the oncoming release, it's been substantially revamped. Hopefully this will result in better performance all around.

      • kmd's avatar
        kmd
        Contributor
        4 months ago

        I sure hope so.  I'm getting tired of hearing "I hate OneStream" from our users

  • tdugas's avatar
    tdugas
    New Contributor III
    4 months ago

    Same issue, it hangs up when trying to save offline and we have to kill the process.  

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    12 months ago

    Sounds like a local infrastructure issue that should be investigated with Support, please get in touch with them.

    • kmd's avatar
      kmd
      Contributor
      12 months ago

      Thanks Jack, that was my next step if I didn't hear from anyone in the community.