Forum Discussion

BWHITAKER's avatar
BWHITAKER
New Contributor II
15 days ago

Preserve Excel Format

The Preserve Excel Format option seems to work for retaining formatting done in Excel when re-opening and refreshing cube views. However, I'm finding that my data is greyed out as if invalidated upon refreshing a cube-view in Excel after the initial connection. I've tried setting the font color to black and that was overridden upon refreshing as well, even though all other formatting is still intact. Perhaps there is a setting I am missing?

Excel Add In
Reports
  • echen's avatar
    echen
    New Contributor
    2 days ago

    There could be a default setting in the cube view in OneStream that is overriding the Preserve Excel Format option. You may want to try checking the default, row, and column settings and changing the cube view font color in OneStream. You could also try creating selections styles in excel and applying them by navigating to the OneStream tab at the top of excel > Cube Views > Selection Styles.