Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-23-2024, 12:06 PM
RetiredCHE RetiredCHE is offline Excel 365 default templates Windows 11 Excel 365 default templates Office 2021
Advanced Beginner
Excel 365 default templates
 
Join Date: Jun 2016
Location: Alabaster, AL
Posts: 33
RetiredCHE is on a distinguished road
Default Excel 365 default templates


Using Win11 Home 23H2 and Office 365 local.

I have customized my Book.xltx and Sheet.xltx files with the font style and size I want for all new files, and that seems to work. But when I set a different color for the gridlines in these 2 files, opening a new blank workbook doesn't have the desired gridline color, or default text in cell A1. The gridlines are the default light grey and all cells are blank. I have stored copies of my customized Book and Sheet files in the 3 locations I've found referenced, but none of them work. One of these locations has my Personal.xlsb file in it, and that does get opened.

Where is Excel getting the template to use for the new blank worksheet? Here are the 3 locations where I have the copies of the Book and Sheet files:
  • C:\Users\alanc\AppData\Roaming\Microsoft\Excel\XLS TART
  • C:\Users\alanc\AppData\Roaming\Microsoft\Templates
  • C:\Users\alanc\Documents\Custom Office Templates

This is driving me crazy; any help will be greatly appreciated.
Retired ChE
Reply With Quote
  #2  
Old 10-24-2024, 03:37 PM
RetiredCHE RetiredCHE is offline Excel 365 default templates Windows 11 Excel 365 default templates Office 2021
Advanced Beginner
Excel 365 default templates
 
Join Date: Jun 2016
Location: Alabaster, AL
Posts: 33
RetiredCHE is on a distinguished road
Default

I also customized the gridline color in these 2 files, but new spreadsheets don't have my custom color either. Where in the world is the default spreadsheet getting its settings?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
(help) Excel Templates for a small online business mailmanager Excel 1 08-16-2024 07:36 AM
Auto-Titles for New Files from Excel Templates / How to set default 'Color Palette' theme SnakeDoctor Excel 1 03-15-2024 10:13 AM
Change default text field entry on templates SamJal Outlook 0 09-22-2014 03:43 AM
Excel 365 default templates Templates, pictures, Mail Merge and Excel kckay Word VBA 1 05-17-2012 08:51 PM
Excel 365 default templates Word/Excel letter templates TracyW Mail Merge 3 04-04-2012 02:21 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:05 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft