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

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

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,181,338
Messages
5,929,389
Members
436,665
Latest member
MonkeyNotDonkey

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