Excel Format as Table Different Colors

Question

I have two workbooks, both formatted as .xlsx and both the 'Normal' styles.

They show different color options in the format table options, why is this?

Answer 1

These captures are from 2016, but 2013 should be substantially similar.

Look in the Page Layout tab > Themes drop down a grid of themes is displayed. Your first example appears to be using a custom Light style in the default "Office" theme

I suspect that you will see that a different theme is selected, "highlighted" in each workbook.

The first one looks like the default "Office" theme, with an additional, "custom" light colored table style <edit theme>.  Here is what mine looks like:

I haven't bothered to look, but if you look carefully at your second screen cap you'll see a substantially different set of options.

Answer 2

Hi,

To isolate the issue further, we’d like to know the following:

• Did you use the same version of Excel to create this workbooks? If not, please specify the versions.
• Have you tried to create a new file and check the color options?
• Did you originally create the workbooks?

We’ll wait for your reply.

Answer 3

Thank you for your help.

Under PAGE LAYOUT >  Colors, it is the difference between the Office Color and Office 2007-2010 palette.