losing cell formatting when saving as .htm

dhermanedina

New Member
Joined
Oct 7, 2002
Messages
2
Greetings,

We use excel to publish a daily status message of issues that our group is monitoring. Merged cells A1->J1 are set to Arial Black, 24 pts and Center/Center. Yet, when I open it again after someone else has used the file, it has reverted back to Arial, 10PT with an alignment of General and Bottom.

What makes this even more intriging is that the Merged cell range, A2-> J2 is set to Arial Black, 24 pts and Center/Center and it KEEPS it cell formatting.

Any suggestions on how to correct this?

I have thought of writing a macro to reformat the cell upon opening but......

Thanks, Dan
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

dhermanedina

New Member
Joined
Oct 7, 2002
Messages
2
Thanks, we just tried that and when someone else opened it, it reverted to the old way.

Any other suggestions or is more info needed?

In case this is important, this is a worksheet that others will enter info into on disparate computers.

And, to make matters even more interesting, I just added a blank row above the offending line, changed the line to the correct format, saved, had my co-worker open and close, and then I reopened the wks and lo and behold, the formatting stuck. Is this an undocumented Excel feature?

Thanks, Dan
This message was edited by dhermanedina on 2002-10-08 09:32
 

Forum statistics

Threads
1,144,330
Messages
5,723,740
Members
422,512
Latest member
MHau5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top