E
eml
Hi.
Have an issue with conditional formatting rules created on excel 2003 and
edited by excel 2007.
I created a series of rules on specific fields of a pivot table. The rules
are applied to many cells on the same column, so that if the pivot table
expands vertically, the new rows are affected by the same rule, too.
Everything has worked perfectly for years. Now, with excel 2007, these rules
are no longer kept. Excel erases all the rules applied to cells inside the
pivot table and moves the rule to cells outside the table. The only solution
I found so far is to re-create the rule with 2007 but other users (who read
the same file using 2003 version) won't be able to read the file like before.
Has anyone else encountered the same problem?
Is there a work around it?
Many thanks in advance.
Have an issue with conditional formatting rules created on excel 2003 and
edited by excel 2007.
I created a series of rules on specific fields of a pivot table. The rules
are applied to many cells on the same column, so that if the pivot table
expands vertically, the new rows are affected by the same rule, too.
Everything has worked perfectly for years. Now, with excel 2007, these rules
are no longer kept. Excel erases all the rules applied to cells inside the
pivot table and moves the rule to cells outside the table. The only solution
I found so far is to re-create the rule with 2007 but other users (who read
the same file using 2003 version) won't be able to read the file like before.
Has anyone else encountered the same problem?
Is there a work around it?
Many thanks in advance.