Prev: I need to link 4 pivot tables that are on a single page.
Next: formula help PLEASE PT 2
From: Sys-Stat on 10 Apr 2010 15:52
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?
From: Dave Peterson on 10 Apr 2010 16:37
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
From: Sys-Stat on 10 Apr 2010 18:00
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
> .
>
From: Dave Peterson on 10 Apr 2010 18:50
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
 | 
Pages: 1
Prev: I need to link 4 pivot tables that are on a single page.
Next: formula help PLEASE PT 2