Tag Archives: Windows

Microsoft 365 Excel Performance Hack for UHD Displays in Windows

If you have a large spreadsheet to edit (ie. 10k+ columns) with your UHD display (ie. 4K or higher resolution) in Microsoft 365 Excel you may have some performance issues when scrolling.

I just found an easy hack that works for me:

  1. Check Disable hardware graphics acceleration in Excel under File – Options – Advanced – Display section
  2. Exit Excel
  3. Change your display resolution to 1920×1080
  4. Change text scale to 100%
  5. Open the spreadsheet you need to edit with Excel
  6. Change your display resolution back to native resolution
  7. Change text scale back to your original option (ie. 200%)
  8. See magic happens

This hack works until you exit your Excel. So you have to redo step 3-8 when openning new documents.

balenaEtcher: Source and destination checksums do not match errors

If you got the following errors:

\\.\PhysicalDrive1: Source and destination checksums do not match: <hash1> !== <hash2>

You can try to disable removable drives to be added to libraries setting for System Volume Information folder creation:

How to prevent creation of “System Volume Information” folder in Windows 10 for USB flash drives?

Remove Ubuntu Dual Boot From Windows Boot Manager

  1. Log into Windows
  2. Click Windows menu, hold shift and left click to restart Windows into Advanced Options menu
  3. Choose Troubleshoot > Advanced Options > Command Prompt, wait for the reboot
  4. After reboot, reselect Windows
  5. In Command Prompt, type bootrec /fixmbr and bootrec /fixboot. Then close the Command Prompt and choose Continue to continue login to Windows
  6. After logging into Windows, run diskmgmt to remove the volumes from Ubuntu

You can also use GUI solution like EasyBCD to remove the Ubuntu boot item from Windows Boot Manager.

如何完整删除 Microsoft Mesenger for Mac

一破 IM 居然是 mpkg 包，mpkg 包吧竟然没 Uninstaller，卸载方法吧竟然我在 Mesenger 开发者 PDF 里才能找到，而且还不全。这是我用 Mac OS X 这两个月来见过最傻逼的 Mac OS X 程序，另外值得一提的是。 Skype for Mac 和此软件有一拼

#!/bin/bash

rm /Applications/Microsoft Messenger.app
rm ~/Library/Preferences/com.microsoft.autoupdate2.plist
rm ~/Library/Preferences/com.microsoft.error_reporting.plist
rm ~/Library/Preferences/com.microsoft.Messenger.plist
rm -rf /Library/Application Support/Microsoft
rm -rf ~/Library/Preferences/Microsoft
rm -rf ~/Library/Caches/com.microsoft.Messenger
rm -rf ~/Documents/Microsoft\ User\ Data

Windows 系统安全设置、权限恢复备忘

以前经常要用开启整个硬盘的共享在 LAN 里实现 2 ways sync，但现在不需要了，可是在权限的设置上却出了点问题，有时候甚至会遇到部分文件夹完全无法访问的情况，虽然手动修改可以扩大权限而继续访问，但如此多的文件同时处理实在是很大的工作量

于是网上搜到了 Xcacls.exe 这个权限工具，于是就有了下面的命令：

d:>icacls * /reset /T /C /Q
e:>icacls * /reset /T /C /Q
f:>icacls * /reset /T /C /Q
g:>icacls * /reset /T /C /Q
h:>icacls * /reset /T /C /Q
i:>icacls * /reset /T /C /Q
j:>icacls * /reset /T /C /Q

需要注意的是，如果文件非常多，例如大于一万个，就会需要一段时间（几分钟至十几分钟）。另外，特定的系统文件夹，例如 $RECYCLE.BIN 与 System Volume Information 的权限也会被覆盖，而不是真正的 “reset to default” 所以使用时需谨慎。最后，在一切都执行完成后，第一次查看分区属性时，有可能会遇到类似 “回收站文件损坏，是否清空回收站” 之类的提示，选择是即可，这是由于权限更改而造成的，以后不会再出现

如果你对统一化后的权限的安全问题担忧，而又不想重装系统来恢复一些系统默认的文件权限，可以考虑 微软给出的重置建议