Fixed: End users redirected to their Delve profile when clicked on OneDrive in Office 365

AppLaunch

Problem: You are redirected to Delve profile when clicked on OneDrive for Business icon in Office 365 instead of opening the OneDrive portal.

Delve Home

To ensure if this is related to Office 365, try to access the OneDrive directly using the link (replace the domain name/user ID to match your environment)

https://mantoso-my.sharepoint.com/personal/manoj_mantoso_onmicrosoft_com/_layouts/15/onedrive.aspx

https://domain-my.sharepoint.com/personal/user_domain_onmicrosoft_com/_layouts/15/onedrive.aspx

If it prompts an error saying you do not have enough permissions. You are reading the right post. This is a well-known reaction of OneDrive when you haven’t configured permissions for end user OneDrive provisioning. So let’s find out how we can make it normal.

Launch Office 365 as an Global Admin (or SharePoint admin) and direct to SharePoint Admin panel –> Classic features (if you are on the modern experience) –> click on “User profiles”

06

07

User profiles will be launched in a familiar SharePoint Central Administration page (classic indeed!). From the People section there, click on “Manage User Permissions

01

Pick the relevant group (perhaps everyone in most cases) and click “Add” it

02

Select the newly added group and let’s grant the permissions by checking the tick boxes –> hit “Ok” to complete. 

03

Try to open it again and verify if the changes are applied properly. Sometimes could left empty even after the change.

Finally try to open a fresh browser session and log in as an end user to Office 365. Click on OneDrive app from the App Launcher and it should smoothly start provisioning the space for you. In a few minutes time your OneDrive is ready for your content.

08

If everything went well, go ahead and inform everyone to start using OneDrive!

Root cause: This problem occurs when the user’s personal site isn’t created and the user doesn’t have permissions to create the site. The site is usually provisioned the first time that a user browses to the page.

Password protected excel files in Excel online

If you are one of those users who heavily rely on excel desktop application and thinking of moving fully cloud, perhaps you must think twice. There are some limitations on excel web app compare to desktop app. Some organizations intend to downgrade their Office 365 E3/E5 plans to E1 due to economical aspects but there are some serious consequences which could impact the business.

Annotation 2019-06-13 144634

Go through this article carefully to understand the full list of limitations – https://support.office.com/en-us/article/differences-between-using-a-workbook-in-the-browser-and-in-excel-f0dc28ed-b85d-4e1d-be6d-5878005db3b6 

Specially as Microsoft stated in the article above, if you have Excel files with password protected, they won’t open in excel online and you will get the message below.

clip_image002

This level of encryption is usually done within the Excel application using the Protect Workbook feature. It simply means you need to key in a password to open the Excel file.

As this is currently unsupported in Office 365 Excel online, let’s find out an alternative to restrict at least certain functions of an Excel Workbook.

There is a workaround for this matter. However, it won’t help if your requirement is to restrict the viewing of the file, but we can restrict changes from others. This means, others will not be able to amend the data or change structure within a workbook but still can open and see it.

To do this, open the desired workbook from your Excel desktop application and click on the required sheet which will be your current sheet in the setting we are going to set. If you have multiple sheets, these steps must be repeated for each one.

clip_image004

Now go to Review section –> Click on “Protect Workbook” option

clip_image006

Provide a password and choose all the fields that you want to restrict others from editing and hit “Ok

Protect sheet – prevents others from editing cells or making formatting changes

Protect Workbook – Prevents others from doing structural changes such as adding, deleting sheets.

Having both these restrictions in place will protect your entire workbook from unwanted alterations. But it wont prevent viewing.

clip_image008

Now, if you close the Workbook and try to open it again from the desktop application, you’d see something similar to below when you try to amend a field. Meaning you have been restricted doing changes to sheets.

clip_image010

Let’s try to open from Excel online. Just right click on the file and click “View Online

clip_image012

Now try to edit a field and you’d see the following message immediately.

clip_image014

Deletion of tabs, rows, columns or sheets (structural changes) are also disabled now.

clip_image016

If you want to revert this lock, open the Workbook from the Desktop app again and say “Unprotect” from the Info section and it will enable the functionalities again.

clip_image018

This could be an option but not really a perfect workaround. If you are on Office 365 E1, limitations like this one is expectable. Bottom-line is – be extra cautious when you downgrade your plan.