Excel Colours

  Declanworld 10:31 02 Aug 05

I've modified the default colours in a Excel file. Unfortunately, it reverts to the default colours each time I open it. This is the only file that this happens to and it's also the only one where I have two windows open - one each for the two main sheets.

Any ideas?

  VoG II 19:39 02 Aug 05

One possible way around this is to change the color palette in Book.xlt.

Book.xlt provides the default styling that all new workbooks will use. So any styling changes made in Book.xlt will automatically be incorporated in every new spreadsheet created.

In the Office XP version of Excel you can find Book.xlt in:

C:\Program Files\Microsoft Office\Office10\XLStart

(If you are on a different version of Office the 10 will be different.)

If there is not a Book.xlt, create a new spreadsheet and save as Book.xlt (use the file type Template (.xlt) in the Save As dialog box).

  Declanworld 22:14 02 Aug 05

Thanks VoG™.

I'd seen this option earlier during Googling. It's strange that Microsoft don't deem a fix necessary.

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5