custom theme imported not appearing in theme

[Abhay]

Hi

I have made a custom theme and saved it. I sent to it to my colleague. He imported it by browsing to location he saved on his system.

However, this custom list got applied to workbook but it did not appeared in list of themes. Please help.

 

[SirJB7]

Hi, Abhay!
Does this help?
https://office.microsoft.com/en-us/...ument-theme-in-word-or-excel-HA010354866.aspx
https://office.microsoft.com/en-us/...ument-theme-in-word-or-excel-HA001229924.aspx
https://office.microsoft.com/en-001...your-custom-theme-color-HA102927238.aspx#BMxl
https://office.microsoft.com/en-au/excel-help/change-the-default-theme-HA010204550.aspx
Regards!

 

[Abhay]

No, I checked above links before posting a question. If I save a new theme it appears in my custom theme but when I share it with others it gets applied but does not show in custom theme. That' s my concern. Above links does not answer this.

 

[SirJB7]

Hi, Abhay!
I don't use themes so even if I could set one I won't be able to check those set by others, would you send your theme or any other for testing purposes? Thank you.
Regards!

 

[NARAYANK991]

Hi Abhay ,

Have you gone through this ?

http://www.itechtalk.com/thread610.html

Narayan

 

[Abhay]

Thanks Narayan and SirjB7 for your reply.

The link provided by Narayan not answered my question however directed me towards it.

The trick is this

When other person browse and select the theme file it will get applied to file but will not show in Custom Themes. I am not sure if this is a loop hole in Excel.

However, if it is copied to Themes Template folder in shared person PC it will show up in Custom and he / she can modify this theme as usual.

I hope you guys got my point and I have not confused. Try sharing themes otherwise.

 

[bobhc]

Abbay

But that is the whole point of what you are doing.

You are making a custom theme in an Excel workbook and then sending it to other, they can see the theme as it is in-bedded in the workbook, they cannot use it in other documents as it is not in the theme collection it need to be put there.

The link that Narayan does at the bottom of the article explain how to export and save the theme on other computers so that it can be used in more workbooks.