missing styles

[Sys-Stat]

I had Excel 2007 crash while several files were open. It auto-recovered them,
but the formatting was gone from one of the workbooks. Now, when I try to use
the comma style for formatting a cell, it tells me that it cannot be found.
Any ideas about how to restore this?

 

[Dave Peterson]

This works in xl2003, but I've never used it in xl2007 (but I bet it works
fine!).

Start a new workbook
verify that the comma style works fine

Open your offending workbook

In xl2003 menus, it's:
Format|Style|then click the Merge button.
(On the ribbon, (maybe) Home tab|Styles Group|Cell Styles Dropdown)

Then merge the styles from the new workbook into this workbook.

Test it and if it works, save your workbook.

Since styles live in workbooks, you'll have to repeat this for every workbook
that broke.

 

[Sys-Stat]

Dave,

Perfect! Worked like a charm.

FYI, in 2007 it is on the Home ribbon under Cell Styles at the very bottom.

Thanks for the tip.

Sys-Stat

 

[Dave Peterson]

Thanks for posting back with the correct location!