Why does Excel open with a blank workbook instead of template options? Why does the ‘New’ tab sometimes show nothing but ‘Blank Workbook’? Why do your colleagues see ‘Invoice’, ‘Budget’, and ‘Project Tracker’ — and you don’t?
The answer isn’t ‘you need a newer version’. It’s about location, licensing, and one hidden setting most people never touch.
Quick Answer
Excel templates aren’t in a single place — they live across four distinct locations: Microsoft’s online template gallery (requires sign-in), your local %AppData%\Microsoft\Templates folder, the Excel startup folder (%AppData%\Microsoft\Excel\XLSTART), and embedded workbook templates saved as .xltx files. Which ones appear depends on your Microsoft 365 subscription status, network connectivity, and whether Excel is set to show online content.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Online Gallery (Microsoft) | Launch Excel → Click 'New' tab → Type keyword (e.g., 'invoice') → Sign in if prompted → Click template | First-time users, cloud-connected teams, up-to-date designs | Fails offline; requires Microsoft account; no custom branding |
| Local Templates Folder | Press Alt+F+T → Options → Save → 'Default personal templates location' → Navigate to folder → Paste .xltx files there | Offline use, company-branded templates, compliance-sensitive environments | No preview thumbnails; manual file management required |
| XLSTART Auto-Load | Place .xltx file in %AppData%\Microsoft\Excel\XLSTART → Restart Excel → Appears under 'Personal' in New tab | Templates you want every new workbook to inherit (e.g., header/footer, fonts, color scheme) | Only loads one per filename — duplicates ignored; no UI preview |
| Open Existing Template File | File → Open → Browse to .xltx or .xltm file → Double-click → Excel opens it as a new instance (not editable original) | One-off use, shared templates via email/SharePoint, legacy .xlt files | No integration with New tab UI; easy to accidentally save over original |
| Power Query + Template Table | Store template metadata in A1:C10 (Name, Path, Category) → Use Data → Get Data → From Table/Range → Load to workbook → Add button to open with VBA | IT-managed template libraries, audit trails, version control | Requires Power Query & basic VBA; not for casual users |
Method 1 Deep Dive
Start Excel. Don’t click anything yet. Press Alt+F+T. That’s File → Options → Trust Center → Trust Center Settings → Macro Settings → Enable all macros (only if you trust the source). No — wait. Stop.
That was a test. You don’t need macros to access templates. What you *do* need is the right path.
Go back to Excel. Press Alt+F+T again — but this time release and press O (Options). In the dialog, go to Save. Look at the field labeled ‘Default personal templates location’. It likely reads:
C:\Users\Sarah Chen\AppData\Roaming\Microsoft\Templates
That folder exists. But it’s empty. So Excel shows nothing.
Create a subfolder called Finance inside it. Copy these two files into it:
Q4_Budget_2024.xltx(based on real Acme Corp Q4 forecast: B2 = $45,200, C2 = $51,800, D2 = $57,300)Vendor_Invoice_Template.xltx(with pre-filled columns: A1='Invoice #', B1='Date', C1='Amount', D1='Status'; cell E5 contains formula=IF(D5="Paid",TODAY(),""))
Now close and restart Excel. Go to New tab. Scroll down past ‘Featured’ and ‘Shared’. Click Personal. Both templates appear — no sign-in, no internet, no delay.
Surprising tip: If you rename Q4_Budget_2024.xltx to ~Q4_Budget_2024.xltx, Excel hides it. The tilde prefix forces exclusion — useful for archiving without deleting.
Method 2 Deep Dive
This method bypasses the UI entirely — and works even when Excel’s ‘New’ tab is frozen or greyed out (common after Group Policy restrictions).
Press Windows+R, type:
shell:appdata\microsoft\excel\xlstart
Hit Enter. You’re now in the XLSTART folder. Drop any .xltx file here — like Internal_Report_v3.xltx.
That file has:
- Sheet1 named 'Data' with range A1:E25 pre-formatted (headers bold, currency in column D, conditional formatting on E2:E25 for overdue dates)
- Sheet2 named 'Summary' with formulas linking to A1:E25 (e.g.,
=SUM('Data'!D2:D25)in B2) - Custom document property 'Department' = 'Procurement'
Restart Excel. Open a new blank workbook. Press Alt+F+N. Under ‘Personal’, you’ll see ‘Internal_Report_v3’. Click it. Excel creates a new workbook based on that template — with all structure, formulas, and properties intact.
Important: Excel only reads files in XLSTART at launch. Adding a file mid-session won’t make it appear until next restart. And if two files share the same name (e.g., Report.xltx and Report.xltm), Excel loads only the first alphabetically — not the newer one.
Cheat Sheet
| Action | Keyboard Shortcut | Where It Lives | Notes |
|---|---|---|---|
| Open Options to set default template folder | Alt+F+T, then O | File → Options → Save | Change path before adding templates |
| Open New tab to browse templates | Alt+F+N | Ribbon top-left | Shows Online, Personal, and Shared sections |
| Jump directly to XLSTART folder | Win+R → paste path | shell:appdata\microsoft\excel\xlstart | No restart needed to view — but needed to load |
| Force refresh of Personal templates list | Alt+F+N → click 'Personal' → press F5 | New tab → Personal section | Works only if folder path hasn’t changed |
| Open template file directly | Ctrl+O → navigate → select .xltx | Any local/network drive | Always opens as new workbook — original stays untouched |
