I have a file with extensively programmed forms created in Excel 03. One of
its actions copies two cells with conditional formatting to another location.
This may happen multiple time as the "plan" being configured with the form
is edited and saved, then modified further at a later time.

Our company has seen fit to allow users to roll over to 2007 when it suits
them. (wow). Now when the 07 users try to use my template file, they
experience what they call "blowing up". Starting from about 700kb for the
template file, as they go through iterations of editing and saving their
work, we've seen the file size increase to as much as 17MB. Their pc's come
to a grinding halt and production goes to hell in a handbasket.

There are also issues related to calculation that are slowing things to a
crawl even when the files don't blow up. So now I get to turn off automatic
calculation, and find all the places where calculate need to happen to
produce valid results and apply the calculation to only the ranges that need
to give up their results for the immediate purpose.

Thanks Microsoft. (and kudos to my company for the approach to roll-out)

"Henk" wrote:

When you copy paste a cell with conditional formatting to another cell with
conditional formatting, the conditional formatting is added to the new
location. Who the **** did invented that?? Anyone any idea how to switch that
off and overwrite the existing format as it used to do (and ought to do, I
think).

Something like Application.OverwriteConditionalFormatting = True would be
nice.

Nobody ran into this problem yet?? I have an enormous lot of code using the
old fashioned overwrite way. Any thoughts and comments about this?

Thanks.