It's now January 2008, and I notice this thread goes back to mid-2007,
without any (apparent) fix by MS. Someone indicated earlier that very
few people use large numbers of rows or columns -- I definitely do, and
that's why I "graduated" to Office 2007. I thought that the interface
between Access and Excel would be much cleaner when both could handle
the 1/2 Million or so rows I generally have in my files. Excel is
incredibly slow even in the simplest activities (I just waited 20
minutes to clear a couple of columns in a 70,000 row spreadsheet).
Inserting blank columns takes forever, even when there are no formulas
in the spreadsheet (I remove the formulas by paste special/values, just
because they slow things down so much).
It seems as if the programs (both Access and Excel) are "anticipating"
what a user might do, and pre-storing or pre-computing stuff --
otherwise, why would a simple column insertion or deletion take so much
time?
I didn't know about being able to save the old Office version when I
installed, so I either have to wait for a real fix from MS, or get on
another computer with Office 2003. Is this what happens when you have a
total monopoly in this product area?


*** Sent via Developersdex http://www.developersdex.com ***