Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
4 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?

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

  • jbrem's avatar
    jbrem
    New Contributor II

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

     

  • boaja11925's avatar
    boaja11925
    New Contributor

    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