Unlocking a Password Protected Excel File

Aside from being an increasingly useful way to create and collaborate on productivity projects, Google Drive also serves as a convenient file unlocker.

Simply upload the file, then download it, being sure to save it with a different file name. As with most import/export operations between Microsoft Office and third-party alternatives, formatting discrepancies may be an issue.

Free SharePoint 2013 Training for IT pros

As an Microsoft Certified Instructor, I often get asked about free training. Well, Microsoft has come thought with 14 different modules on SharePoint 2013 including changes and new features.  Check them out at the link below.

http://technet.microsoft.com/en-US/sharepoint/fp123606

Connecting a SharePoint 2013 Calendar to Outlook

Navigate to the calendar that you want to connect to Outlook. In this example, I will navigate to the Birthday Calendar.

     Next, I will click on the Calendar tab, then Connect to Outlook. If your Connect to Outlook button is disabled, refresh your page. This is part of the Minimum Download strategy Feature for SharePoint 2013.

Next, you will need to allow the connection to Outlook. I will select the Allow button.

 

 

 

Outlook will open and then I will need to add the connection to the SharePoint Calendar. To do this, select the Yes button.

You will notice that the calendar is opened in Outlook next to your personal calendar.

 

 

Slide Library in SharePoint 2013?!

Thanks to Mike Smith's blog, we have answered a valuable question that many people ask me about.

http://techtrainingnotes.blogspot.com/2012/11/finding-missing-sharepoint-2013-slide.html

The Slide Library is not listed as an "App" or displayed in the old Create.aspx page (_layouts/create.aspx). But… you can still get it with a direct URL. I would not depend on the being there forever as the Slide Library is officially not in 2013, but for now you can create one.

The direct URL to create the old Slide Library:

http://yourserver/sites/yoursite/_layouts/15/slnew.aspx?FeatureId={0be49fe9-9bc9-409d-abf9-702753bd878d}&ListTemplate=2100

.

Update 11/9/12: I just tested the Office 365 (2013) Preview and it works there too!

I just tried it with Office 365 SharePoint Online and it worked like a charm. - 11/23/2013

Thanks Mike!

Hiding All Site Content in SharePoint 2010

All Site Content is located on the Quick Launch in the master page. You will need to edit the master page on usually v4.master or your custom master page.  

              
The "All Site Content" link or button is created using a SharePoint control named ClusteredSPLinkButton. The control can be hidden from selected users by changing the PermissionsString attribute.

For example, changing this to PermissionsString="DeleteListItems" would hide this control from users that can't delete items from a list, documents from a document library, and Web discussion comments in documents.

<SharePoint:ClusteredSPLinkButton 
id="idNavLinkViewAllV4" 
runat="server" 
PermissionsString="ViewFormPages" 
NavigateUrl="~site/_layouts/viewlsts.aspx" 
ImageClass="s4-specialNavIcon" 
ImageUrl="/_layouts/images/fgimg.png" 
ImageWidth=16 
ImageHeight=16 
OffsetX=0 
OffsetY=0 
Text="<%$Resources:wss,quiklnch_allcontent_short%>" 
accesskey="<%$Resources:wss,quiklnch_allcontent_AK%>" 
/> 

How to hide the Ribbon in SharePoint 2010

Hiding the ribbon to any user that can't delete items

1.       Navigate to the master page of the site that you wish to hide the ribbon of.

2.       Right click on the maserpage in SharePoint Designer and select Edit File in Advanced Mode

3.       Using Code view or split view, locate the <SharePoint:SPRibbon

4.       Insert before <SharePoint:SPRibbon. In this example, insert on line 61

<Sharepoint:SPSecurityTrimmedControl runat="server" PermissionsString="DeleteListItems">

5.        Navigate to the closing of the SharePoint Ribbon </SharePoint:SPRibbon>

6.       Insert </SharePoint:SPSecurityTrimmedControl>. In this example, it is line 27

7.       This will hide the ribbon to anyone that does not have the permissions to delete items.

See this MSDN article for a list of PermissionsString options: http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spbasepermissions.aspx