Sharepoint - Excel File freeze panes

Is it possible to store an excel file that is formatted with frozen panes in a SharePoint gallery or library and have the user that clicks on it see the frozen panes? I can't find a clear answer that states whether or not it is possible for this to happen.
LVL 1
susnewyorkAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Ah, this is Web Excel. It does not have the same functionality as desktop Excel and many Excel features will not work.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

an Excel file with frozen panes will show the frozen panes when opened. It does not matter if the file is stored in a SharePoint library, a file server folder or anywhere else.

cheers, teylyn
0
 
susnewyorkAuthor Commented:
Well, currently the file is in a sharepoint gallery and is opened in the web browser. The panes are not frozen after the file loads. If I save the file and store it locally, the panes are frozen.

Do you know of a work around for this, except for downloading and storing the file locally? Thanks!
0
 
susnewyorkAuthor Commented:
Thank you,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.