Forum Discussion

johnal67's avatar
johnal67
Contributor
11 days ago

Refreshing an emailed spreadsheet

We just upgraded from 8.4 to 9.0, and almost certain before we could email a spreadsheet with XF functions and immediately refresh the spreadsheet with button in the ribbon when already logged in.  Now the Refresh Sheet button is grayed out, and now you have to "save as" the spreadsheet then refresh because the spreadsheet is in "read only" mode.  I'm trying to decide if it changed with the upgrade, or if one of the Preferences settings affect this, or if we are just not remembering correctly.  Any ideas or are we just wrong?

Excel Add In

1 Reply

  • KerrieL's avatar
    KerrieL
    New Contributor III
    11 hours ago

    You are correct, prior to version 9 you could refresh a file with XFGetCell functions while the file was in read-only mode, whether that file was in read-only mode after being opened from an email or after another user had already had the file opened.    However, refreshing in a file that is in read-only mode is not possible with version 9.  We opened a case for this issue and OneStream confirmed this change was a version 9 enhancement and that it is included in the release notes for version 9.  We are planning to submit an entry on IdeaStream to either restore the refresh functionality to what is was prior to version 9 or to make the functionality a general preference in the add-in.