Your thoughts on Excel 2003 to Excel 2007
 

Hi all,

Can you share some thought with me on the migration from Excel 2003 to
Excel 2007? Are there any instances of deprecated functions/ objects? Or
Is it 100% compatible Excel 2003?

Thanks,

Ben

Your thoughts on Excel 2003 to Excel 2007
 

I had a couple of problem areas that required re-coding to resolve.

First had to do with conditional formatting. In 2003 it was no problem when
my code made it possible to copy a cell with conditional formatting multiple
times to the same location. In 2007, it became completely unworkable. In
2007 the "feature" of copying conditional formatting causes the conditions to
simply be ADDED to the destination cell existing cf conditions. Intuitively
everyone seems to think it should REPLACE, but it just ain't so. Weird
things start to happen when you pile more and more conditions on top of a
single cell.

Second is the increased size limit of rows and columns and how that impacts
the speed of calculation. I've seen many reports of files that worked great
with 2003, and because of this issue, they slow down enough to cause big
headaches. If your code causes changes to cells that would trigger a
recalculation, then you'll want to set calculation mode to manual, and
explicitly perform the calculate action just when you need it. Takes a
little more thinking about where your code is drawing on calculated values
and whether they need to change in response to other steps.

Those are the main ones I know of, but I believe there are others as well.
Someone else can pitch in with what they know.

"Ben" wrote:

Hi all,

Can you share some thought with me on the migration from Excel 2003 to
Excel 2007? Are there any instances of deprecated functions/ objects? Or
Is it 100% compatible Excel 2003?

Thanks,

Ben

Your thoughts on Excel 2003 to Excel 2007
 

Ben wrote:
Hi all,

Can you share some thought with me on the migration from Excel 2003 to
Excel 2007? Are there any instances of deprecated functions/ objects? Or
Is it 100% compatible Excel 2003?

See all the previous threads on the extent of MFUs in Excel2007.

I still do not recommend "upgrading" to it *unless* there is some
critical essential benefit for your organisation. The biggest disaster
area is graphical objects and charts which are glacially slow.

XL2003 is robust stable and quick enough to be useful. XL2007 is none of
these things. It is getting better - maybe after SP4 it will be OK...

Regards,
Martin Brown

Your thoughts on Excel 2003 to Excel 2007
 

Thanks slarbie and Martin.

Ben

On 9/3/2009 4:19 PM, Ben wrote:
Hi all,

Can you share some thought with me on the migration from Excel 2003 to
Excel 2007? Are there any instances of deprecated functions/ objects? Or
Is it 100% compatible Excel 2003?

Thanks,

Ben