[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Sharepoint - Excel File freeze panes

Posted on 2014-03-11
4
Medium Priority
?
1,591 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 50
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 (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.
0
 
LVL 1

Author Closing Comment

by:susnewyork
ID: 40337411
Thank you,
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

656 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