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...