Sharepoint - Excel File freeze panes

Posted on 2014-03-11
Medium Priority
Last Modified: 2014-09-22
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.
Question by:susnewyork
  • 2
  • 2
LVL 50
ID: 39922719

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

Author Comment

ID: 39924166
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!
LVL 50

Accepted Solution

Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 1500 total points
ID: 39924635
Ah, this is Web Excel. It does not have the same functionality as desktop Excel and many Excel features will not work.

Author Closing Comment

ID: 40337411
Thank you,

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Watch the video to know how one can repair corrupt Exchange OST file effortlessly and convert OST emails to MS Outlook PST file format by using Kernel for OST to PST converter tool. It can convert OST to MSG, MBOX, EML to access them. It can migrate…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question