Keep freeze panes with excel book

[OSAdmin]

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?

[TonyToniTone]

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

[jbrem]

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

[boaja11925]

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