The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,917 other followers

Archive for March 1st, 2022

Some links on repairing the Windows Recovery partition after cloning a Windows 10 disk

Posted by jpluimers on 2022/03/01

Somehow after cloning a Windows 10 disk to SSD, the regular partition worked fine, but the recovery partition (sometimes called WinRE: short for Windows Recovery Environment or Windows RE) didn’t.

In short, I only had to perform two actions to get this fixed, both from the Administrator elevated command prompt:

  • Set the partition ID of the Recovery partition from 7 to 27 (this is for an MBR disk; for GPT disks, these values are different, see the first link below). I did this using diskpart.
  • Re-enabling the Recovery partition by executing reagentc /info to check if it was disabled, then reagentc /enable (if it wasn’t disabled first, I had to precede it with reagentc /enable).

    Before this, bcdedit /enum would only return the Windows Boot Loader entry for the C: drive, but had no recoverysequence and now it had.

Since there are cases where much more action is needed, here are some links for just when I run into more complicated situations:

Read the rest of this entry »

Posted in Power User, Windows, Windows 10 | Leave a Comment »

Learned that figuring out Excel formula dependencies has been there since at least Excel 2000 (:

Posted by jpluimers on 2022/03/01

Sometimes, you figure out Excel functionality you have never needed before, but has been there for decades.

A while ago, I had a very complex with formulas referencing full columns back and forth when suddenly I got into something strange: when reloading the spreadsheet, values would not appear because of recursion errors. Before saving this was fine, so it was hard to track back where I want wrong.

So I was happy to find out that Excel has two cool features for this:

  • Trace Precedents
  • Trace Dependents

Heck, looking at the icons I had a feel these features had been there for a long time. Boy, was I surprised to find them in [Wayback] Excel 2000 – Student Edition – Complete (a great book by the way), as you can see in this picture:

Excel 2000 - Student Edition - Complete - Trace precedents, dependents, error

Excel 2000 – Student Edition – Complete – Trace precedents, dependents, error

As others can explain this feature so much better than I can, here are some links:

–jeroen

 

Posted in Excel, Office, Office 2000, Office 2003, Office 2007, Office 2010, Office 2011 for Mac, Office 2013, Office 2016, Power User | Leave a Comment »

Booting Windows 10 to the recovery console command prompt

Posted by jpluimers on 2022/03/01

I bumped into an old draft on notes on NTFS boot issues.

A while ago, I wanted to boot in the Windows 10 “Safe Mode” console, but the F8 option during the boot process was gone.

So I wondered how to get there. There seem to be a few ways, of which almost all require a functioning Windows installation. When you have one, it is relatively easy, as these options will work as summarised from [Wayback] How to open the Windows 10 recovery console:

  • Hold the physical Shift key when choosing “Reboot” in the user interface. There are various ways to get to the “Power” button:
    • in the lower right corner at the logon-screen
    • in the lower right corner at the lock-screen
    • in the lower right corner after pressing CtrlAltDel
    • in the lower left corner of the “Start” menu
  • In the Settings app, there used to be an “Advanced Startup” feature, but I could not find that any more in Windows 10 version 21H1 any more
  • From a console Window, run either of these commands (the second waits zero seconds before rebooting, the first 30)
    • shutdown.exe /r /o
    • shutdown.exe /r /o /t 0

There is also a possibility to restore the F8 functionality, but you need installation media for it. [Wayback] 3 ways to boot into Safe Mode on Windows 10 version 21H1 explains how to.

Some “notes on NTFS boot issues” links for my archive

(Note that for some of the links, only the [Wayback] ones work: link-rot of the links I saved 6 years ago)

–jeroen

Read the rest of this entry »

Posted in Internet, link rot, Power User, Windows, Windows 10, Windows 7, Windows 8, Windows 8.1, WWW - the World Wide Web of information | Leave a Comment »

 
%d bloggers like this: