J
Jobowo
Has anyone come across a problem with Excel 2007 Tables?
I frankly don't have much use for tables but since Microsoft
shortsightedly placed table autoformatting on the other side of this
barrier, I often convert a range to a table and the convert it back to
a range leaving the formatting in place.
Trouble is, when I convert a table back to a range I find that the
area defined is now troublesome--chiefly, formulae no longer work!
I suspect the problem is the boneheaded new referencing method that
Microsoft uses for Tables (which is what, for me, makes Tables totally
useless: one referencing system is enough). It converts formulae to
the "new" referencing system and then not either can't convert them
back or breaks the recognition for formulae altogether.
It might be just my configuration. I have to have Excel XP AND Excel
2007 on my system and that too is a source of problems.
I frankly don't have much use for tables but since Microsoft
shortsightedly placed table autoformatting on the other side of this
barrier, I often convert a range to a table and the convert it back to
a range leaving the formatting in place.
Trouble is, when I convert a table back to a range I find that the
area defined is now troublesome--chiefly, formulae no longer work!
I suspect the problem is the boneheaded new referencing method that
Microsoft uses for Tables (which is what, for me, makes Tables totally
useless: one referencing system is enough). It converts formulae to
the "new" referencing system and then not either can't convert them
back or breaks the recognition for formulae altogether.
It might be just my configuration. I have to have Excel XP AND Excel
2007 on my system and that too is a source of problems.