Good morning forum,
The company I work for has a wonderful IT dept and we are just starting to use Office 2007. Excel 10 was a trusted old friend, and I miss it tremendously. Anyway, excel 2007 appends conditional formating rules to existing rules on paste (whether or not they are before or after the existing rules doesn't matter), it adds to the existing rules. It doesn't always do it, but when it does, among other things, you get a loss of functionality warning when saving to an .xls file because you exceeded the number of rules allowed (obviously not in all cases). This is a major headache for me. I've seen only a couple of postings on this, like from Andrew Poulsom, but no answers. Anyone know of an easy button to get around this behavior?
The company I work for has a wonderful IT dept and we are just starting to use Office 2007. Excel 10 was a trusted old friend, and I miss it tremendously. Anyway, excel 2007 appends conditional formating rules to existing rules on paste (whether or not they are before or after the existing rules doesn't matter), it adds to the existing rules. It doesn't always do it, but when it does, among other things, you get a loss of functionality warning when saving to an .xls file because you exceeded the number of rules allowed (obviously not in all cases). This is a major headache for me. I've seen only a couple of postings on this, like from Andrew Poulsom, but no answers. Anyone know of an easy button to get around this behavior?
