Default Style

[Rory]

G'day All

I was wondering if anyone could help me with the
following problem.

I would like to have a customised default style for
the 'comma', 'percentage', and 'currency' for every
workbook (new and existing).

I have created the styles I'm after under the 'Format-
Styles' menu. Also, I have looked up the "Save Styles to
use in new workbooks" in the HELP function and did
everything it said. However, when I open up a new
workbook, my styles are not there. What is there are the
original style settings with each style duplicated.
Eg 'Comma, Comma[0]'.

I realise that in the HELP menu for "Save Styles to use
in new workbooks" it only refers to styles 'will be
available in all new workbooks that you subsequently
create', but I would like it so that my customised styles
are automatically set when I go into my old workbooks.

MS Excel ver 2002
Win XP Pro

Thanks for any help
R

{Side issue - do you think it would be possible to take
Microsoft to court and sue them under the Trade Practices
Act for providing a product(s) that are not
of "merchantable quality"? - in non-legal terms,
Merchantable Quality is defined as something that is fit
for the purpose being used}

 

[Gord Dibben]

Rory

About the best you can do with old workbooks is copy the styles from the new
workbook.

From Help on merging styles..................

Copy styles from another workbook
Open the workbook that contains the styles you want to copy.
Open the workbook you want to copy the styles to, and then click Style on the
Format menu.
Click Merge.
In the Merge styles box, double-click the workbook that contains the styles
you want to copy.
Note If the two workbooks contain styles with the same names, you must
confirm that you want to merge these styles. To replace the styles in the
active workbook with the copied styles, click Yes. To keep the styles in the
active workbook, click No. This warning occurs only once, regardless of the
number of conflicting style names.

On the second matter, why not? We are a litigious society and if you have the
bucks, fill your boots.

Gord Dibben Excel MVP

 

[Rory]

Thanks Gord

That is what I did do (you just repeated what was in the
HELP menu) and it didn't work. Any other suggestions?

-----Original Message-----
Rory

About the best you can do with old workbooks is copy the styles from the new
workbook.

From Help on merging styles..................

Copy styles from another workbook
Open the workbook that contains the styles you want to copy.
Open the workbook you want to copy the styles to, and then click Style on the
Format menu.
Click Merge.
In the Merge styles box, double-click the workbook that contains the styles
you want to copy.
Note If the two workbooks contain styles with the same names, you must
confirm that you want to merge these styles. To replace the styles in the
active workbook with the copied styles, click Yes. To keep the styles in the
active workbook, click No. This warning occurs only once, regardless of the
number of conflicting style names.

On the second matter, why not? We are a litigious society and if you have the
bucks, fill your boots.

Gord Dibben Excel MVP

G'day All

I was wondering if anyone could help me with the
following problem.

I would like to have a customised default style for
the 'comma', 'percentage', and 'currency' for every
workbook (new and existing).

I have created the styles I'm after under the 'Format-
Styles' menu. Also, I have looked up the "Save Styles to
use in new workbooks" in the HELP function and did
everything it said. However, when I open up a new
workbook, my styles are not there. What is there are the
original style settings with each style duplicated.
Eg 'Comma, Comma[0]'.

I realise that in the HELP menu for "Save Styles to use
in new workbooks" it only refers to styles 'will be
available in all new workbooks that you subsequently
create', but I would like it so that my customised styles
are automatically set when I go into my old workbooks.

MS Excel ver 2002
Win XP Pro

Thanks for any help
R

{Side issue - do you think it would be possible to take
Microsoft to court and sue them under the Trade Practices
Act for providing a product(s) that are not
of "merchantable quality"? - in non-legal terms,
Merchantable Quality is defined as something that is fit
for the purpose being used}

.

 

[Gord Dibben]

Rory

All I can do is state "it works for me" and repeat what is in the Help file
for Excel 2002.

After merging, some styles are not automatically applied.

Only the "Normal" style is automatically rendered on the old workbook sheets.

To format the old workbook with the merged comma, percentage and currency you
must select the cells and Format>Style then select the merged style.

What do you mean by "it didn't work"?

Gord

Thanks Gord

That is what I did do (you just repeated what was in the
HELP menu) and it didn't work. Any other suggestions?

-----Original Message-----
Rory

About the best you can do with old workbooks is copy the styles from the new
workbook.

From Help on merging styles..................

Copy styles from another workbook
Open the workbook that contains the styles you want to copy.
Open the workbook you want to copy the styles to, and then click Style on the
Format menu.
Click Merge.
In the Merge styles box, double-click the workbook that contains the styles
you want to copy.
Note If the two workbooks contain styles with the same names, you must
confirm that you want to merge these styles. To replace the styles in the
active workbook with the copied styles, click Yes. To keep the styles in the
active workbook, click No. This warning occurs only once, regardless of the
number of conflicting style names.

On the second matter, why not? We are a litigious society and if you have the
bucks, fill your boots.

Gord Dibben Excel MVP

G'day All

I was wondering if anyone could help me with the
following problem.

I would like to have a customised default style for
the 'comma', 'percentage', and 'currency' for every
workbook (new and existing).

I have created the styles I'm after under the 'Format-
Styles' menu. Also, I have looked up the "Save Styles to
use in new workbooks" in the HELP function and did
everything it said. However, when I open up a new
workbook, my styles are not there. What is there are the
original style settings with each style duplicated.
Eg 'Comma, Comma[0]'.

I realise that in the HELP menu for "Save Styles to use
in new workbooks" it only refers to styles 'will be
available in all new workbooks that you subsequently
create', but I would like it so that my customised styles
are automatically set when I go into my old workbooks.

MS Excel ver 2002
Win XP Pro

Thanks for any help
R

{Side issue - do you think it would be possible to take
Microsoft to court and sue them under the Trade Practices
Act for providing a product(s) that are not
of "merchantable quality"? - in non-legal terms,
Merchantable Quality is defined as something that is fit
for the purpose being used}

.

 

[Dave Peterson]

I read the help for xl2002 and it said to save the book.xlt to your templates
folder.

I've always saved this special template workbook (and sheet.xlt) into my XLStart
folder.

Clicking on the New icon should have a new workbook based on that book.xlt file.

G'day All

I was wondering if anyone could help me with the
following problem.

I would like to have a customised default style for
the 'comma', 'percentage', and 'currency' for every
workbook (new and existing).

I have created the styles I'm after under the 'Format-
Styles' menu. Also, I have looked up the "Save Styles to
use in new workbooks" in the HELP function and did
everything it said. However, when I open up a new
workbook, my styles are not there. What is there are the
original style settings with each style duplicated.
Eg 'Comma, Comma[0]'.

I realise that in the HELP menu for "Save Styles to use
in new workbooks" it only refers to styles 'will be
available in all new workbooks that you subsequently
create', but I would like it so that my customised styles
are automatically set when I go into my old workbooks.

MS Excel ver 2002
Win XP Pro

Thanks for any help
R

{Side issue - do you think it would be possible to take
Microsoft to court and sue them under the Trade Practices
Act for providing a product(s) that are not
of "merchantable quality"? - in non-legal terms,
Merchantable Quality is defined as something that is fit
for the purpose being used}

 

[Rory]

G'day Gord

What I mean when I say "it didn't work for me" is that
after I've done all changing, removing of old styles,
saving etc, I exit Excel then re-enter the program. (if
every thing has been done correctly I would assume that
the changes I've made are reflected in the default
workbook that opens up with the program). I then try the
format buttons of "Comma", "Currency" and "Percentage"
and find that the old format is still being used. I look
into the 'Format - Style' menu and find the old styles
still there and none of my created styles.

In relation to the use of my styles in old workbooks - I
suspected that I would have to manually merge them, but I
was hoping there might have been a quick / automatic way
this could have occurred.

Thanks
R