Shortest possible blog article. Just remember and use the shortcut when there is a sudden disturbance (cough, phone ringing, etc.)
OneDrive No Entry Sign is one of the icon states of OneDrive / OneDrive for Business on Windows 10. (Reading time 3 min).
It looks like this
It means your OneDrive account is not active – for some reason. You can’t access the files unless you resolve the issue. Here are the possible reasons:
OneDrive No Entry Sign
Account expiry is probably the most common reason. Check your subscription status and renew it. Sometimes, you think the subscription is active but the associated credit card may have expired.
Some Promotions give you extra space. Promotion expiry also leads to a frozen OneDrive account. For example, Samsung mobile purchases have / had a 100 GB OneDrive space promotion. This is limited to a one-year period. After this period, your files using the extra space will be considered as exceeding the quota.
Other option is that you are using more than the quota. OneDrive allows you to exceed the allotted quota temporarily – but after 3 months, it will freeze the account.
The files will not be deleted. But you must act on it and streamline the account either by increasing the quota or deleting unwanted files. Otherwise, after some time the files will be deleted. Exact time for which files are kept is shown in the OneDrive account.
Therefore, OneDrive No Entry Sign should be noticed as soon as it appears and you must act on it quickly.
OneDrive No Entry – buy Office Home
If you are just using OneDrive personal and run out of space, the logical option is to buy more space. But there is a better option. Buy Office Home. It comes with OneDrive…
If you buy the entry level Office Home edition, it gives you 6 TB of space – at just 500 INR (9.99 USD) per month.
In addition to this, you get full Office Pro Plus – for 6 PCs / Mac and Mobile devices. Unbelievable value for money. When you compare this to other pure storage vendors, there is simply no comparison. The OneDrive integration with devices (Windows, Mac, Mobile devices) and Office is absolutely top-class. Nothing comes close to it.
The only shortcoming I have seen is that on many occasions, the latest OneDrive client is not installed. Or worse still, the old and the new version coexists. In these cases, OneDrive does not work well. The solution is easy. Just use Windows 10 and make sure you have all patches updated.
Related : OneDrive Knowledge Pack (10 articles as of Sep 2019)
Video recording of the YouTube Channel Optimization session conducted at CIO Crown event in Mumbai, Hyatt Regency, Aug 2019. Attended by 180+ CIOs from across India. The importance of YouTube for corporate usage was explained along with tools and techniques.
The 30 minute video is fast-paced and covers content creation, SEO, Metadata, Community Engagement, Channel Customization and more…
YouTube Channel Optimization: Table of Contents
There are hundreds of icons in Office. Many new ones were added recently (May 2019). Adding icons is easy – Insert – Icons – search for an icon or see it and choose it. Multiple icons can be added. It is easy enough. Why do I need to write how to add icons?
Because there is a very nice feature available which makes adding multiple icons really easy – but it is not obvious. Why is it not obvious? Because we usually don’t think of our convenience. We are used to inefficiency!
Adding multiple Icons in Office
Suppose I want to add three icons – one for laptop, one for idea and one for mobile. What will you do? One of the two things…
- Add one icon at a time by going to the Insert Icon three times.
This is obviously inefficient.
- Go to Insert Icon – when you find the mobile icon by scrolling, you see the Laptop icon next to it – so you add two of them together. But for the Idea icon, you have to do more scrolling or go to the dialog once more. Again – inefficient.
Add multiple unrelated icons in one stroke
Go to the Insert – Icons dialog. Use the search text box to find what you want. Select the icon. DO NOT insert it yet. Search for another one, find it, select it. Repeat it till all icons are found. Even if the search results do not show it, your selections are remembered.
The Insert button shows how many it has remembered in brackets. So, don’t worry about inserting icons. Just find the set of icons you want and then insert all of them once and for all.
We usually don’t notice this level of sophistication and end up going to the dialog repeatedly to add multiple Icons.
Here is the video of how to insert multiple Icons in Office
Now that you know, use it to your advantage. Cheers!
This article consists of a video and a macro. PowerPoint Jigsaw Creator works on any picture. First step is to split the picture into random pieces and second step is to put those pieces in random position. Then you can use Morph to create a nice effect where the pieces of the puzzle automatically fit in and create an amazing effect like this…
Watch this video to know how to do this. In addition, you will need to download and use this macro. See instructions below. Continue reading PowerPoint Jigsaw Creator
Probably nobody noticed it. But this is an example of how Microsoft is looking at even the smallest inconveniences and resolving them to improve efficiency. In order to understand this topic, you have to know how to perform the QAT customization – Quick Access Toolbar. You can read this article for details.
While customizing QAT, you see two lists. The list on the left side has thousands of items – all available features in the product. The list on the right side contains items which are already there in your QAT.
The idea is to find the desired item from the main list and add it to the right side list. Now, in the longer list, if you wanted to find, let us say the item “Split”, you could not type the characters s p l. Basically, incremental search did not work at all. If you typed s p l it will show you the first entry of l rather than the entry starting with spl.
This required lot of scrolling and manual searching because it is a very long list. It is not a major issue but a small irritant. However, recently, Microsoft solved this and now, the long list supports incremental search. In short, you type spl together and it will go to Split item (in Word).
We usually miss incremental improvements
The reason I am writing this article is that, most probably, I would have missed this improvement altogether. Why? Because for many years the list did not support incremental search. Once we know that something is not going to work, we just don’t try it.
Luckily, I tried it recently, hoping that true to its continuous improvement thought process, Microsoft may provide incremental search some day. And it did work.
A classic example of missing incremental improvements is associated with Excel. In older versions, if you click inside a cell and type CTRL A the entire sheet would get selected. What we wanted is to select the block of data around the selection. People just gave up on CTRL A.
But somewhere down the line (I don’t remember the exact version), Microsoft did enhance Ctrl A to select the current region of contiguous data. Unfortunately, most users who were earlier disillusioned with CTRL A never tried it again and they still don’t know that CTRL A works.
Such if life!
If you post a long video to YouTube, it is a good idea to add a Table of Contents to the description. This helps viewers go to specific topics quickly. In my case, I post the video link + TOC on my blog as well. The link format for YouTube and regular HTML are totally different. That is why I made an Excel based YouTube TOC creator.
This is a jump start for using Office efficiently. It is called Office Efficiency Crash Course because it contains 120 “must know” things across Word, Excel, PowerPoint, Outlook, OneNote and OneDrive.
This session was conducted for 400+ MBA new joiners at WeSchool, Mumbai.
3 hr, 20 min video. Fast paced. With lot of demos.
Office Efficiency Crash Course Table of Contents
It is a long video. You may want to see a particular product. Here is the product specific Table of Contents. Click on the link to jump to that part in the video.
120 topics are covered. Here is the detailed table of contents. Continue reading Office Efficiency Crash course
This is a recording of the session conducted at WeSchool – Welingkar Institute of Management, Mumbai on 23rd Jun 2019. All business users will find this video useful. Work Efficiency Transformation using Office 365 is relevant to any organization using the Office 365 platform.
Duration: 3 hr 12 min
This video demonstrate efficient usage of various tools including Outlook, Excel, Power BI, OneDrive, Teams and Planner.
The audience consisted of 200+ working professionals pursuing the WeSchool MBA course. Smart and attentive audience. In spite of it being a Sunday, everyone was fully engrossed and interested in learning more. Special thanks to Prof. Pradeep Pendse who invited me to conduct the session, it was a pleasure addressing such a large and intelligent audience.
Table of Contents
Here is the recording of my session conducted at CIO Power List 2019, at Pune, India.
This was a two part session. Only the second part was recorded. Here I demonstrate quick but powerful features of Office 365.
These features will be instantly popular and will help you drive adoption further.