The page you requested does not exist in Excel Interactive View: SharePoint 2013

Issue: One of internal user when using Excel Interactive View with excel service was getting the error message:

Error: The page you requested does not exist.

Environment: SharePoint 2013, Office 2013, Windows 7.

Troubleshooting:

Every troubleshooting start with the basic steps such as checking the

•        Office package
•          Office repairs
•          Settings on Document Library
•         Repair via Office diagnostics etc.

However, in this case it this error was a bit tedious as I have never worked Excel Interactive Views in the SharePoint 2013. I think I should also shed some light on what is Excel Interactive View is?

Excel Interactive View is a brand new technology introduced in Excel Services 2013. Excel Interactive View uses HTML, JavaScript, and Excel Services to generate Excel table and chart views on-the-fly, in the browser, from an HTML table hosted on a web page. By using Excel Interactive View, users can harness the analytically power of Excel for use on any HTML table on any web page, in most browsers, without having Excel installed.

Reference: http://msdn.microsoft.com/en-us/library/office/jj163261(v=office.15).aspx.

Resolution: I found a MS KB article which talks about the same behavior and http://support.microsoft.com/kb/2761245.

It describe the cause of the issue, that is occurs because of the history management technology that is used by the webpage. This history management technology uses a number sign to pass the previous state of the webpage contained in the browsing history

To get rid of the issue, you need to remove the webpage versions history or recommended to create a new webpage and start over and make sure webpage URL should not contain a number sign (#).

Reference: http://msdn.microsoft.com/en-us/library/office/ms575980(v=office.15).aspx

         http://technet.microsoft.com/en-us/library/cc748833(v=office.12).aspx

If you have any difficulty in resolving this issue, please drop your query in comment section below.

Products applies to: SharePoint Server 2013, Office 2013. 

SharePoint 2010: Office Documents missing properties missing

Issue

A user has a issue saying whenever they any password protected document on SharePoint such as word, Excel or Power Point Document their document properties went missing.

---

Error

There is no error however, when you view properties of any SharePoint document they will be missing.

---

Background

User had three mandatory fields on a SharePoint document library. When editing the document after checkout, it allows him to select the properties and save the document. However, when he refreshes his SharePoint Library, the document properties went missing.

---

Environment

Windows 7, Office 2010 and SharePoint Server 2010.

---

Troubleshooting

Created a document with the password protection and uploaded to SharePoint and if did clears out the properties.

Tried doing this with the password protection and its working fine.

Tried the same things on other types of documents and is showing the same behaviour.

---

Resolution

My last post explains the reason for this http://mossnwss.blogspot.co.uk/2014/01/document-properties-are-clearing-out.html.

Microsoft claims that this is the by design behaviour that when you protect any document with encrypted password it will protect the meta data associated with the document.

However there is workaround suggested by Microsoft.

Start –> Run –> regedit

Navigate to HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\14.0\common\security

Note
Version 14.0 is shown if you have Office 2010.  Office 2007 will be 12.0, and Office 2013 will be 15.0.

Note
You might have to create a few keys

Look for the property OpenXMLEncryptProperty.  If it is not there, create it as a REG_DWORD.  Set the value to 0. 

---

References

• http://social.technet.microsoft.com/Forums/office/en-US/49567cf4-3a29-46fd-90be-42efd1301fb2/password-protected-files-and-metadata?forum=sharepointgeneralprevious
• http://technet.microsoft.com/en-us/library/cc178978.aspx
• http://blogs.technet.com/b/office_integration__sharepoint/archive/2014/02/06/office-2010-error-during-check-in-of-password-protected-files-to-sharepoint.aspx

---

Applies to

SharePoint server 2010, Office 2007, Office 2010.

---

Cumulative Updates: SharePoint Server 2013 and SharePoint 2010

September, 14 Cumulative Updates for SharePoint Server 2013:

http://support.microsoft.com/kb/2883068

September, 14 Cumulative Updates for SharePoint Foundation 2013:

http://support.microsoft.com/kb/2883068

September, 14 Cumulative Updates for SharePoint Server 2010:

http://support.microsoft.com/kb/2883103

September, 14 Cumulative Updates for SharePoint Foundation 2010:

http://support.microsoft.com/kb/2889932

http://support.microsoft.com/kb/2889909  

Applies to: SharePoint Server 2013, SharePoint Server 2010, SharePoint Foundation 2013 and 2010.

Getting started with your First site in SharePoint 2013.

I think being on the support side and project side of SharePoint. I should start sharing the how to stuff on SharePoint 2013 for end user readers.

Having said that I am going to touch base on the first site look and things it described. 

This is how a site looks like initially and we can add stuff based on our needs and can remove them.

We are going to talk about the each option one at a time.

Share your site:

This option is more like giving permissions to someone to visit you site with different permissions. 

Once you click on it you get the option to Share your site with the colleagues in your organization.

You can invite people by searching using their names, Email id and can share it everyone in your company.

You can also quote your personal message with this and can select to send invite via Email and can choose permissions as well.

An Email will be triggers to that person whose name you had selected to be invited on the site.

Then person can follow any feeds you will be posting on the site.

Working on a Deadline?

This is nothing I would say gives you similar option as we have seen in previous versions of SharePoint. It gives you option to create the Task and Calendar list though with an improved features and functionalists.

This is how a task list will look like. You can create new items in it and add more stuff based on what you would like to see in particular.

Calendar list is just most like we had in previous versions. We are not going to talk in much detail on these as it would need whole new topic to discuss the feature of these.

Add Lists, Libraries and other apps.

This option gives choices to add content to your site. Like, document library, form library, wiki page library, picture library and many more.

This option only shows the out of the box options you got with SharePoint 2013, however, you can add your own custom app, can request for new apps and manage the license of the already requested ones. 

What your style?

This are let you configure the style or theme of your SharePoint site. You can choose from various default templates to give a new look to your SharePoint site. You can customize the templates as well by publishing some solutions on the SharePoint gallery.

Your site, your brand.

option gives you privileges to add your own logo or brand logo on the site.

You can change the site Title, Description, Logo and description of the logo. This area also allowed choosing the site logo from your computer as well.

 I hope the initial touch-base to the First SharePoint site must be useful to you.

Product Applied to: SharePoint Server 2013, SharePoint Foundation 2013.

SharePoint 2010 Troubleshooting: Tracing Service failed to create the trace log file. Error 5: Access is denied.

Issue

We have certainly noticed that SharePoint diagnostics logs had stopped working and have seen Event ID 5401 and 6457.

---

Background

 We have SharePoint Server 2010 running on Windows Server 2008, since few months Diagnostics logs were not being captured.
We did notice it when we try to get the logs for the some other troubleshooting.
The Diagnostics Logs folder was empty.

---

Error

Event ID’s 5401 and 5457 were reported thoroughly. In our event logs.

Event ID 5401

Log Name: Application
Source: Windows SharePoint Services 3
Date: 03/09/2014 14:48:09
Event ID: 5401
Task Category: Unified Logging Service
Level: Error
Keywords: Classic
User: N/A
Computer: <Compute Name>
Description:
Tracing Service failed to create the trace log file at <’Location of the logs folder’>. Error 5: Access is denied.

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
 <System>
 <Provider Name="Windows SharePoint Services 3" />
 <EventID Qualifiers="0">5401</EventID>
 <Level>2</Level>
 <Task>301</Task>
 <Keywords>0x80000000000000</Keywords>
 <TimeCreated SystemTime="2014-09-03T13:48:09.000000000Z" />
 <EventRecordID>47490</EventRecordID>
 <Channel>Application</Channel>
 <Computer><Computer Name></Computer>
 <Security />
 </System>
 <EventData>
 <Data>D:\Test</Data>
 <Data>5</Data>
 <Data>Access is denied.
</Data>
</EventData>
</Event>

Event ID 6457

Log Name: Application
Source: Windows SharePoint Services 3
Date: 03/09/2014 14:45:10
Event ID: 6457
Task Category: Unified Logging Service
Level: Error
Keywords:      Classic
User: N/A
Computer: <Computer Name>
Description:
Not enough free disk space available. The tracing service has temporary stopped outputting trace messages to the log file. Tracing will resume when more than 220 MB of disk space becomes available.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
 <System>
 <Provider Name="Windows SharePoint Services 3" />
 <EventID Qualifiers="0">6457</EventID>
 <Level>2</Level>
 <Task>301</Task>
 <Keywords>0x80000000000000</Keywords>
 <TimeCreated SystemTime="2014-09-03T13:45:10.000000000Z" />
 <EventRecordID>47489</EventRecordID>
 <Channel>Application</Channel>
 <Computer>><Computer Name></</Computer>
 <Security />
 </System>
 <EventData>
 <Data>220</Data>
 </EventData>
</Event>

---

Troubleshooting

Restarted the tracing service on all WFE’s and index server, but it did not help.
Checked the disk space on the server and we had ample space on the drives.
Have followed the steps given in the TechNet article http://technet.microsoft.com/en-us/library/cc561048(v=office.12).aspx, but it did not help as well.
Created a Test folder and tried to update the location in Central admin diagnostics tab but was stil having the same issue.

---

Resolution

Looking at the access denied part reported in the event viewer. We have compared the setting of the Diagnostic folder with other platforms we have and noticed that the account under which tracing services was running was not added.
That account was Local Service account (may be different based on how your environment is set-up).
Added the LOCAL SERVICE account with correct level of permissions and restarted the tracing service and it did fixed the issue i.e. logs started to generate.
If you have any queries, please post in the comments below. I will be happier to help you.

---

Applies to:

• SharePoint Server 2010
• Windows Server 2008 R2

---