Forum Discussion

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
5 years ago

Keep freeze panes with excel book

Originally posted by Chris Matthews

We are able to freeze panes with a cube view export straight to excel but when the same cube view is used in a book the freeze panes is lost. Is there a setting or way to keep the freeze panes?

Books
Cube View

4 Replies

  • jbrem's avatar
    jbrem
    New Contributor III
    2 years ago

    any plans to get this in place for excel reports in book?

     

  • boaja11925's avatar
    boaja11925
    New Contributor
    2 years ago

    I was wondering this same thing.  I have a client that currently has several books they dump into Excel and they have to manually freeze the panes in each tab of each book they export to Excel.  The Cube View is set up to have the freeze panes applied and when you export it to Excel they stay in place.  It is just the book form where all the tabs lose the frozen panes.  Thanks

  • TonyToniTone's avatar
    TonyToniTone
    Icon for OneStream Employee rankOneStream Employee
    4 years ago

    Unfortunately, freezing panes in Excel for a Report Book is currently not available at the time of this question. 

    • LinaU's avatar
      LinaU
      New Contributor II
      11 months ago

      Hello! Has anything changed around freezing panes in Report Books when exporting to Excel? Curious if there have been updates since this was last mentioned a few years ago.