Q: "How do I point Connect for Office at a Sandbox?"

A: Connect for Office, which enables (1) embedding reports in Excel spreadsheets (handy!) and (2) customizing Mail Merge templates in Word, can also work with Sandbox data. This document explains how to redirect Connect for Office to point at a Sandbox org.