Excel: BLOCKED CONTENT Macros in this document have been disabled…


You have downloaded an Excel document with macros from (known/excepted) website. When you open this Excel file, you get this error: BLOCKED CONTENT Macros in this document have been disabled by your enterprise administrator for security reasons. There is a possibility System Administrator might have created a GPO to block Macros. If not, there is … Continue reading Excel: BLOCKED CONTENT Macros in this document have been disabled…

Solution: “The Feature You Are Trying to Use in on a Network Resource That is Unavailable”


Other day Zoom Outlook add-in was trying update itself and keep failing with "The Feature You Are Trying to Use in on a Network Resource That is Unavailable". It keep asking for downloaded setup/MSI file. Well...I found the solution that works for me; deleting a Freaking Registry Key. Here it is: Open Registry Editor Go … Continue reading Solution: “The Feature You Are Trying to Use in on a Network Resource That is Unavailable”

Exchange Online/OWA: Where is the HELL is “Send event invitations in iCalendar format” option?


Do you have IMAP/POP3 users? It amazes me to see the some stubborn users refused to use Microsoft Outlook on their Mac/Windows computers. They uses the limited featured IMAP client. Hey! Whatever makes you happy, I guess. Are they looking for the option "Send event invitations in iCalendar format" in OWA settings? This options converts … Continue reading Exchange Online/OWA: Where is the HELL is “Send event invitations in iCalendar format” option?

Office 365: How to restore deleted OneDrive in PowerShell?


If an employee leaves the company, few managers wants the OneDrive content of the ex-employee. Few occasions it is business critical to take the documents from ex-employees' OneDrive and re-share it again. So how do you do that? I wrote the following script that does exactly that. Before you run the script, make sure you … Continue reading Office 365: How to restore deleted OneDrive in PowerShell?

New kind of fresh HELL: Problem Ejecting USB Attached SCSI (UAS) Mass Storage Device. This device is currently in use


I ran into this issue of not able to eject an USB disk. Before you ask the question, I have set the disk for "Better Performance". So I have to eject the disk before I remove it. (FYI, I would suggest to use "Better Performance" for bigger disks like 1TB or above to get most … Continue reading New kind of fresh HELL: Problem Ejecting USB Attached SCSI (UAS) Mass Storage Device. This device is currently in use

How to sync any folder to OneDrive?


Do you want to sync/backup directories that out side of OneDrive sync'ed directory? For example, you have a directory at "D:\SDCard\PortableApps\PNotesPortable" and you want take a backup to OneDrive. You have come to right place. This works for OneDrive (consumer) as well as OneDrive for Business. Here is how you do it. Creating a junction … Continue reading How to sync any folder to OneDrive?

Exchange Online: Calendar Permissions – “Some Permissions cannot be displayed”


I needed remove few disabled users from the permission set in the Calendar. I got this error: "The security principal specified is already on the permission set". To fix this error, I was using my other blog post: https://anandthearchitect.com/2018/06/29/get-mailboxfolderpermission-the-security-principal-specified-is-already-on-the-permission-set/. Here is the wrinke. If you have Full Access permission to a mailbox, when you open … Continue reading Exchange Online: Calendar Permissions – “Some Permissions cannot be displayed”