ToolSmith

The Fix Library

Every guide on ToolSmith, grouped by software. Each one: symptom → cause → exact clicks → how you know it worked. Can't find your error? Request it — reader requests go to the front of the queue.

Excel & Google Sheets

Formula errors, imports, and the messages that eat your afternoon.

Excel

Fix the #SPILL! error (FILTER, XLOOKUP, dynamic arrays)

Clear blocked cells, unmerge, remove the @ — by cause.

 Excel

Fix the #REF! error

Recover from deleted references and stop it happening again.

 Google Sheets

Fix IMPORTRANGE not working / #REF!

The "Allow access" click everyone misses, plus four more causes.

Windows 11

Printers, updates, and update screens that never move.

Windows 11

Printer shows offline

Five steps in the order that works most often.

 Windows 11

Windows Update stuck

From the quick restart to the DISM rebuild.

Gmail & Google Drive

Limits, stuck uploads, and the built-in flows that solve them.

Gmail

Attachment too large (25 MB)

Use the Drive insert flow properly — any file size.

 Google Drive

Upload stuck at 0% or "Processing"

Check quota first, then cache, names, and resync.

Mac, Chrome & Network

Batteries, connection errors, and Wi-Fi that lies.

Mac

Battery not charging / "Service Recommended"

Battery Health explained, cable checks, and the SMC myth.

 Chrome

ERR_CONNECTION_RESET

Isolate site / browser / network, then reset the stack.

 Network

Wi-Fi connected but no internet

One test tells you PC or router — fix only the broken one.

We use cookies for ads and analytics. Read our privacy policy.