Excel Column Freeze (Export/Book)
Hello,
Is there a way to determine where the freeze panes will be placed in a cubeview upon the export to excel? It looks to default wherever the headers end, but I have a view where I'm calling a...
Forum Discussion
Why not just view the Cube View in Excel, as opposed to exporting from the Data Explorer view to Excel.
If you have an Excel worksheet where you put the freeze panes on whatever row you like, and then use the Excel add-in (or Embedded Spreadsshet) to insert an existing Cube View into a certain location in your spreadsheet, then all you have to do is refresh it.
This saves having to go into the OneStream Client, opening the CubeView in Data Explorer mode, and then exporting to a new excel file every time.