Solved

Sharepoint - Excel File freeze panes

Posted on 2014-03-11
4
1,297 Views
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.
0
Comment
Question by:susnewyork
  • 2
  • 2
4 Comments
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 39922719
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
 
LVL 1

Author Comment

by:susnewyork
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!
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 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.
0
 
LVL 1

Author Closing Comment

by:susnewyork
ID: 40337411
Thank you,
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

803 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