I encountered this error the other day and hadn’t seen it before:
When starting any office program by opening a file, the user saw: “There was a problem sending the command to the program.” Then when dragging the file to Excel, the file opened fine. What the heck?!
Turns out you have to turn off something called DDE (Dynamic Data Exchange) in the settings. This Microsoft KB article details the problem.
Go to the Office app in question and go to the Options. From there, click on Advanced and make sure “”Ignore other applications that use Dynamic Data Exchange (DDE)” is UNCHECKED like below in my version of Excel 2016.
This works for Office365 or an internal Exchange server to disable the calendar on a Shared Mailbox or User’s Mailbox. First, you’ll have to pull up the Exchange Management Shell. Then run the following commands:
New-OwaMailboxPolicy –Name “New Policy Name”
Creates a new mailbox policy
Set-OwaMailboxPolicy –Identity “New Policy Name” –CalendarEnabled $false
Sets the calendar for all mailboxes under the policy to be off
Set-CASMailbox –Identity “shared mailbox” –OwaMailboxPolicy “newpolicy”
Applies the policy to the mailbox in question
Ran into this this week. Even though I hate doing it and definitely don’t recommend it, I had to enable CIFS on a Server 2012 instance. To do this, you first have to install the “SMB 1.0/CIFS File Sharing Support” Feature, and then do the following:
Open the Registry Editor, go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer and change the value of DependOnService from SamSS Srv2 to SamSS Srv.
Reboot the server and that’s it! Enjoy your legacy application / device!
Ran into this one today… the Office 2016 Preview for Mac crashes. The solution is to open Terminal and run the following commands:
defaults delete com.microsoft.Outlook
They delete old preference files and then kill cached preferences. Voila!
After configuring Wake On Lan via Command Configure in a previous post, I then wanted to enable Bitlocker on the Windows 8 machine. Unfortunately, the Dell laptop did not have TPM enabled in the BIOS, which allows for a secure key to be saved. Command Configure to the rescue!
There are a few commands you have to run. For some reason, Dell requires you to have a BIOS password to enable the TPM. Don’t worry, you can enable it and disable it all at once without needing to reboot the machine. Here is what you need to run:
cctk –setuppwd=biospassword // This sets a BIOS password
cctk –tpm=on –valsetuppwd=biospassword // This turns TPM on and provides the BIOS password you set previously
cctk –tpmactivation=activate –valsetuppwd=biospassword // This activates TPM and provides the BIOS password you previously set
cctk –setuppwd= –valsetuppwd=biospassword // This removes the BIOS password. Just put one space after the = sign. You need to feed the old BIOS password to make the change.
That is it! You’ll have to restart the computer and Windows will see the TPM device and be able to enable Bitlocker.
I’ve been playing with Dell Command Configure recently and will be doing a few posts on my work.
First up is enabling Wake On Lan (WOL) on Dell Optiplex, Latitude, XPS, Insprion, systems. The main advantage is this can be done remotely, through Windows, and can even be scripted.
You’ll need Dell Command | Configure which you can grab from here. If you are interested in more features, you can read up on the full documentation in the Reference Guide here.
After you install it, you can open the aptly named “Command Configure Command Prompt” tool. From there, you can enter all your arguments that you want to change. To change your Wake On Lan settings, simply type in:
cctk –wakeonlan [enable, disable, enablewakeonwlan, lanorwlan]
The options above are what you can do. You can set it to wake on just wireless, or both wireless and ethernet LAN. For both wlan and lan, your command would be:
cctk –wakeonlan lanorwlan
3/19/2020: I have written an updated post with updated information and usage here.
With the growing popularity of SSDs, a lot of users have been using SSDs for boot drives and HDDs for storage. In Windows 10, there is an exciting new feature which will automatically and seamlessly let you choose what folders and files get put on a secondary HDD. This includes “My Documents”, “My Pictures”, and even applications.
The setting is under Settings > System > Storage and can be seen below:
I’ve encountered this more times then I’d like to say. Basically, when you create a VPN connection in Windows it automatically routes ALL traffic, even traffic not for the remote LAN over the VPN connection. This slows things down considerably. To stop this, do the following:
- Go into the Properties of the VPN Connection
- Go to the Networking Tab
- Select TCP/IPv4 and click “Properties”
- Hit “Advanced” and then uncheck “use default gateway on remote network”
- Click OK until you are out of the menu system
That is it!
In case you’re wondering, the simplified upgrade paths to Windows 10 are as follows:
Free Upgrade to Windows 10 Home:
If you own any of the below editions, you will get the free upgrade to Windows 10 Home edition:
- Windows 7 Starter
- Windows 7 Home Basic
- Windows 7 Home Premium
- Windows 8.1 (without Pro)
- Windows 8.1 country specific editions
- Windows 8.1 Single Language
- Windows 8.1 with Bing
Free Upgrade to Windows 10 Pro:
Below versions will receive the free upgrade to Windows 10 Pro edition:
- Windows 7 Professional
- Windows 7 Ultimate
- Windows 8.1 Pro
- Windows 8.1 Pro for Students
An easy way to get a mailbox usage report is via the Get-Mailboxstatistics commandlet in powershell and a combination of other commands. The below script will output a mailbox usage report in HTML format:
Unlimited | Get