susnewyork
asked on
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.
ASKER
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!
Do you know of a work around for this, except for downloading and storing the file locally? Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you,
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