Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
missing styles
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
missing styles
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 wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
missing styles
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" wrote: 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 wrote: 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 . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
missing styles
Thanks for posting back with the correct location!
Sys-Stat wrote: 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" wrote: 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 wrote: 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 . -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
some unknown Cell styles are shown in cell styles | Excel Worksheet Functions | |||
Chart Styles | Charts and Charting in Excel | |||
Creating styles | Excel Discussion (Misc queries) | |||
Excel Cell Styles - Quick Styles? | Excel Discussion (Misc queries) | |||
New Cell Styles | New Users to Excel |