SharePoint Online has the ability to audit different actions that take place and then allow an administrator to view a report on these. Here is how you configure and work with SharePoint Online auditing.

You will firstly need to access the SharePoint Online Site Collection you wish to enable auditing on as an administrator.

In the top right hand corner of the site select the Cog icon to reveal the menu shown above.

From the menu that appears select Site settings.

From here under Site Collection Administration in the lower right select Site collection audit settings.

If you can’t see this option then you are either not at the root of the Site Collection or you don’t have Site Collection administration rights.

You should now see the options displayed above. In most cases all of the options here will be blank or unselected. This means that by default auditing on Site Collection is not enabled and you won’t be able to get any results until you enable something. So, if you need to track something, turn it on beforehand.

By default, logged items are removed (trimmed) when they are more than 30 days old at the end of the month by default. Using the above options you can vary this and well as nominate a SharePoint Document Library into which audit reports will be saved before the audit log is trimmed.

You will notice in the events to be audited it doesn’t include Opening or downloading documents, viewing items in lists, or viewing item properties option as it does with SharePoint on site at this point in time.

Once you check the items you desire, select the OK button at the bottom of the page to update your preferences and have them take effect.

Now, events that you selected to be audited will generate logs that you can view.

Once a suitable time period has elapsed, return to the Site Settings and select Audit log reports from the Site Collection Administration area in the lower right hand side.

You should now see a range of reports you can view. Some of these reports, such as the first one, Content Viewing, will not run as it is not possible to audit such events with SharePoint Online as has been mentioned above.

In this case however, select the Content modifications option to proceed.

You will then be prompted to enter a location into which to store the report. Simply select an existing Document Library by using the Browse button.

The report should complete successfully and provide a hyperlink, Click here to view the report, which you should select.

A good thing with SharePoint Online is that it incorporates Office Online, which means Excel Online should now open to display the spreadsheet report as shown.

The first tab, Audit Data – Table, will provide a summary of the events as shown above.

While the second tab, Report Data 1, will provide more granular information as shown above.

So in summary, you’ll need to enable auditing on the events you wish to log within each individual SharePoint Online Site Collection. You’ll then need to run the audit reports to view the results after auditing has been enabled.

For more information see the following link:

Configuring audit settings for a site collection

Many users are familiar with traditional drive letters when it comes to saving Office documents. In some cases they struggle to understand the transition to UNC paths, navigating to web based locations or opening from a browser. To help them with this transition they can pin common SharePoint Online document locations to their favourite Office applications access menus.

Now, the traditional way to add a SharePoint location to an Office application was to locate to that location in SharePoint (i.e. a Document Library) and then select the Library tab in the top left. That revealed the Ribbon Menu. On this Ribbon Menu, towards the right, you would find the button Connect to Office. Selecting this would then map that location into your Office documents to make it easy to open those files directly.

Alas, from what I can determine this option doesn’t current work with SharePoint Online in Office 365. So here’s an alternative.

If I open Word on the desktop as shown above you can see that I am not currently logged into my Office 365 account. I do this by selecting the Sign in to get the most of Office in the top right.

I’ll now be prompted to enter my Office login details. I may also be prompted to enter my password if the system doesn’t recognise me.

Once I have logged in successfully, my identity will appear in the top right as shown.

Now when I go to open a document you see that I have already have my standard SharePoint Online Team site (Sites – CIAOPS here) and my personal OneDrive for Business (OneDrive – CIAOPS here). If I select my Team Site, on the right you’ll see a folder with your Team Site (in this case the folder CIAOPS).

If you select this folder, Windows Explorer will open and so you your normal SharePoint Team site (i.e. http://tenant-name.sharepoint.com, here http://ciaops365e1.sharepoint.com). So you can now navigate to the file that you need to open.

However, what happens if you need to regularly open a file from a completely different site collection you have created? That is, with a different URL from your normal Team Site?

Easy. Just select the Browse button and when Windows Explorer comes up change the URL in the path to be the one you want. In my case I have changed the URL to a completely separate Site Collection located at http://ciaops365e1.sharepoint.com/sites/test.

Navigate to the location you want to save and open a single file from there.

If you now navigate back to the Open location option in the Office application you should see the new location listed as above. To save this location so it can be reused to open files simply hover over the entry and you should see a push-pin at the right. Press this to ‘pin’ it there.

With the item pinned, every time you restart the Office application it will be there to allow you select files from there, even though, in this case, it is in a different Site Collection from the standard Team Site.

Hopefully by now you know that when it comes to SharePoint, SharePoint Online and OneDrive for Business there are limitations when it comes to syncing files to your desktop. Most of these are contained in the article:

https://support.microsoft.com/en-us/kb/2933738

Interestingly, when it came to filenames there were certain characters, that if in a filename, would prevent that filename from syncing. Generally, these characters were the same for SharePoint Online and SharePoint on premises. However, as someone pointed out to me this is no longer the case.

The above article details how the ‘&’ character is no longer invalid for SharePoint Online but remains so for SharePoint Server 2013. When you read the article you’ll also see that there are beginning to be quite a few differences in what is permitted between SharePoint Online and SharePoint Server 2013. This is clearly an indication that SharePoint Online is being updated much faster than SharePoint Server 2013.

So now you’ll have to check the above article a little more closely to see exactly what is an isn’t permitted for different versions of SharePoint.

If you are working with SharePoint Online and you go to Site Settings you might not see Web Designer Galleries displayed like so:

The reason that it no longer appears is because many of the Gallery options require scripting and this comes with security issues. So, Microsoft has elected to disable this by default.

To re-enable this scripting option so you can see the Web Designer Galleries, do the following:

Login to the Office 365 portal as an administrator and select the Admin icon from the App launcher.

In the bottom left of the Admin portal, select SharePoint under Admin.

This will take you to the Sharepoint admin center as shown above.

Select Settings at the bottom of the list on the left.

Select the option to Allow and save the changes.

It may take up to 24 hours for these changes to flow through to SharePoint Online and until you can see the Web Designer Galleries options in Site Settings.

For more information on enabling these scripting options in Settings from Microsoft visit:

Turn scripting capabilities on and off