Skip to main content
B
BWHITAKER
December 6, 2024

Preserve Excel Format

  • December 6, 2024
  • 1 reply
  • 0 views

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?

1 reply

E
echen
December 19, 2024

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.

Terms & ConditionsAccessibility statement