Sunday, July 20, 2014

Office 365 Videos

Watch these videos to become familiar with Office 365 and how to read email, share documents, and more.
Share or publish your Office 365 calendar
Share or publish your calendar so others can view your appointments and meetings.
Create a shared mailbox
You can create a shared mailbox in Office 365 so that a group of people can view and respond to email from a common mailbox.
Manage passwords
Learn how to manage passwords for your organization. Change password expiration and reset forgottenpasswords, for yourself and others.
Manage user accounts
As an admin, you need to perform a variety of tasks to keep your organization running smoothly. Learn how to add users, update user information, and transfer licenses and buy new licenses.
Set up your custom domain in Office 365
Set up your own domain name with Office 365 Small Business so your customers and partners can use an easy-to-remember email address to contact you.

Training resources for Office 2013 and Office 365

Training resources for Office 365:

If your organization signed up for Office 365 and you need to start reading email, sharing documents, and more, see the following resources to get started with Office 365:

·         Get started with Office 365
·         Get started with the new Office
·         Install Office with Office 365

Office 365 Videos:
The following Office 365 videos are available:

Office 2013 Suite:

Access 2013 Suite:

Excel 2013:

Lync 2013:

Office offline:

OneNote 2013

Outlook 2013:

PowerPoint 2013:

Project 2013:

Publisher 2013:

Word 2013:

Visio 2013:

Wednesday, July 9, 2014

MCSA: Office 365

Earning an MCSA: Office 365 certification qualifies you for a position as a software as a service (SaaS) administrator or cloud applications administrator focused on managing Office 365 business productivity products like Exchange, SharePoint, and Lync

Managing Office 365 Identities and Requirements: Required Exam: 70-346

Enabling Office 365 Services: Required Exam: 70-347


SharePoint 2010 July 2014 Cumulative Updates

July 2014 Cumulative Update for SharePoint 2010 has been released.

SharePoint Foundation: KB2883026

SharePoint Server 2010: KB2883005

Office 2010 July 2014 Cumulative Updates: KB2978161

July 2014 Cumulative Update for SharePoint 2013

July 2014 Cumulative Update for SharePoint 2013 has been released.

SharePoint Foundation: KB882999

SharePoint Server 2013: KB2882989

Project Server 2013: KB2882990

Office 2013 April 2014 Cumulative Updates: KB2978164

Thursday, June 12, 2014

SharePoint 2013 June 2014 Cumulative Updates

June 2014 Cumulative Update for SharePoint 2013 has been released.

SharePoint Foundation -  KB2881063
http - //

SharePoint Server 2013 - KB2881061
http - //

Project Server 2013 - KB2881062
http - //

Office Web Apps Server 2013 - KB2881051
http - //

Office 2013 June 2014 Cumulative Updates - KB2970262
http - //

SharePoint 2010 June 2014 Cumulative Updates

June 2014 Cumulative Update for SharePoint 2010 has been released.

SharePoint Foundation - KB2880975

SharePoint Server 2010 - KB2880972

Project Server 2010 - KB2880974

Office 2010 June 2014 Cumulative Updates - KB2970263

Thursday, May 22, 2014

April 2014 cumulative update packages

April 2014 Cumulative Update Packages for SharePoint Foundation 2013 and SharePoint Server 2013 have been released

April 2014 CU for SharePoint Foundation 2013 - KB 2863892
April 2014 CU for SharePoint Server 2013 - KB 2878240

Access Denied when we start SharePoint 2010 approval workflow

Access Denied when we start SharePoint 2010 approval workflow

  • From the workflow reports I found an error  -" The workflow could not update the item, possibly because one or more columns for the item require a different type of information."
  • Created a test list without content 
  • Got the same error on all ootb approval workflow
  • Disabled content approval on the list, still got the same issue
  • During troubleshooting found – "Update the approval status after the workflow is completed (use this workflow to control content approval)" enabled on the workflow
  • First disabled it on test workflow as we already have content approval enabled for the list
  • Checked workflow behavior
  • It worked successfully, so chnaged and applied the same settings to prod workflow
  • Once all testing done successfully on test list, implemented the same settings to actual list 

Solution and Cause:
  • "Update the approval status after the workflow is completed (use this workflow to control content approval)" enabled on the workflow
  • Workflows started working by removing check box option from this option

Monday, May 19, 2014

SharePoint 2010 awesome resources

You might need to practice SharePoint 2010 a lot more but unavailability of such high configuration is common and you might need all the funds to invest for such machines but as many many people listed online and as MS did a great job in getting us the virtual labs available to us. 
I saw this MSDN blog online and thought that the publisher Eric Lingman did a great job in putting up the links in here. 

SharePoint Server 2010 Virtual Labs
In addition to the SharePoint Server 2010 Virtual Labs, here are a few other SharePoint 2010 resources that I thought you might also be interested in:
Lets learn all we can for free … happy learning.

Friday, May 16, 2014

InfoPath 2010 gives "A problem caused the program to stop working correctly. Please close the program. "

Yesterday we had an issue reported by a few users that the InfoPath form library would just not open on a few desktops only, for the sake of information all other users and the effected ones were using IE 8 and InfoPath 2010. There was no difference in the environments.
What would happen is if you open a form from a Sharepoint library it would download in infopath and throw an error message as "A problem caused the program to stop working correctly. Please close the program. " and give you a close this program button.

We started troubleshooting

  • We checked for the IE 32 and 64 bit then recent patch installed.

According to a lot of links in internet they recommend KB2760406 and but this patch wasn’t installed on our clients machine.
  • Checked the event viewer and got the error as
  • Faulting Module Name: IPEDITOR.DLL version14.0.7010.1000

We also doubted the IPEDITOR.DLL to run a repair by running SFC / Scannow that did not help.

( )

Query parameters are lost when you open a new form in InfoPath 2010
Although we did not have the KB 2553210 which causes this issue we were still able to resolve the issue.

This resolution seems like a mystery to me but has saved our lifes, posting it so you guys can use it and also make me understand if possible why did this work J

Wednesday, May 7, 2014

Office 2013 Integration with SharePoint 2013

As we all are now inclined towards the new SharePoint 2013 and frankly not many of us have it in our organizations and Labs it makes it more interesting, so I was watching some videos with Office and Share points Latest Integration and found out some interesting points. I am putting it out here

1.       Co-authoring feature in Office 2013 with SharePoint 2013 so people with typical SharePoint experience (from 2007) might find this weird because we work on check in and check out, with co-authoring the document can be checked out to more than one user and yes if you want to know how it works, well the part your editing shows up via Blue line like a Square bracket and that potion is locked for you, you also get notifications when some other people are editing the document which is highlighted by green highlighter once they save it.

This makes it easier to edit the same page when you have to rush with work on a document, brilliant Microsoft!!!

2.       Co-authoring locks lines in WORD and locks Slides in PowerPoint Presentation.

3.       Calendars from SharePoint  can by synced in your Microsoft Outlook they can also be overlaid, because looking at two calendars is not a great thing to do
Image source:

4.       You can also sync your outlook calendar back to SharePoint but you need the appropriate permissions to do that, once you sync the items it takes about 20 minutes to reflect on the calendars.

5.       Everything that you create in One Note stores the files in the SkyDrive, you can permission, share the OneNote notebooks from SkyDrive.

6.       You can chose just a table in your excel workbook and publish it to SharePoint, this builds and active connection between excel and SharePoint list, so later anything added to the Sharepoint List is synced to excel and anything added in excel is synced to Sharepoint.

7.       You can save the documents to Sharepoint from the Word and Excel > going to file save as > web location and give in your SharePoint site.

8.       Microsoft InfoPath is used to created forms and publish it to Sharepoint as a list, initially InfoPath was launched to work with the Biztalk server but now Sharepoint itself had the BizTalk server included.

9.       You can use the InfoPath Form designer to create the form in InfoPath. The fields can be added first and then moved to the form always remember to use the CAML case to name the fields like.  First Name should be FirstName.

10.   When the form is published from InfoPath to Sharepoint you will be prompted twice for authentication, first one will be to create a library in Sharepoint and second one will be to replace the template.

11.   We can create Apps in Microsoft access that needs to be use in Sharepoint.

12.   You can export table from Access to Sharepoint and also import table from Sharepoint to access. Again editing data in either Access or Sharepoint will edit the data in the synced counterpart.

13.   Microsoft Visio files uploaded in Sharepoint will open up with Visio web browser, which makes it easier to comment and discuss on the file before publishing it.

Hope these pointers are helpful for you to understand the integration between Office 2013 and Sharepoint 2013 integration.

Popular Posts


The opinions expressed on this blog are the personal views of Pratik's SharePoint Blog, and do not represent or reflect the viewpoints or policies of any past, present, or future employer, colleague, or customer, or any other entity. The posts on this blog are provided ‘as is’ with no warranties, express or implied, and confer no rights. Use of information contained within this blog, including specific technical steps mentioned herein, is at your own risk. References to specific software products, processes, resources, or companies do not imply any endorsement.