12-29-2008, 03:21 AM
Doc,
The MacBook Pro is a 2.5GHz Intel Core 2 Duo (sorry I did not specify this) with 4GB SDRAM running 10.5.5. The spreadsheet that I was running the other day (one of several spreadsheets, actually) had 1345 rows. I pulled several columns of information into it via VLOOKUP. Once the calculation is complete, I do a copy/paste special/values routine to fix the data. The copy part of the routine ran for 20 minutes or more. One time I copied several columns; another time I copied only two columns.
I am getting the same thing on my accelerated G4 Audio Video machine running 10.4. (latest updates). Long copy times in 2008 that do not happen in 2004.
Both versions, 2004 and 2008 of Excel have the problem of crashing while writing formulas although 2008 seems to be worse meaning that the crash happens fairly often in 2004 but very often in 2008. The crashing happens with VLOOKUP and with COUNT functions. I spend most of my time using Excel, so I don't spend a lot of time with other programs, but Entourage 08, Appleworks, and a variety of browsers all work with no crashing at all. Both 2004 and 2008 crash while writing these functions on both machines. The copies of 2004 on both machines were installed from the same CD and the copies of 2008 were installed from the same DVD. We purchased several licenses but one media in each case.
I thought that the crashing while writing a formula was related to my Mac until a Windows using colleague asked me about Excel crashing while writing formulas. The only thing common to his Windows machine and my Macs is that we log onto the same network.
The MacBook Pro is a 2.5GHz Intel Core 2 Duo (sorry I did not specify this) with 4GB SDRAM running 10.5.5. The spreadsheet that I was running the other day (one of several spreadsheets, actually) had 1345 rows. I pulled several columns of information into it via VLOOKUP. Once the calculation is complete, I do a copy/paste special/values routine to fix the data. The copy part of the routine ran for 20 minutes or more. One time I copied several columns; another time I copied only two columns.
I am getting the same thing on my accelerated G4 Audio Video machine running 10.4. (latest updates). Long copy times in 2008 that do not happen in 2004.
Both versions, 2004 and 2008 of Excel have the problem of crashing while writing formulas although 2008 seems to be worse meaning that the crash happens fairly often in 2004 but very often in 2008. The crashing happens with VLOOKUP and with COUNT functions. I spend most of my time using Excel, so I don't spend a lot of time with other programs, but Entourage 08, Appleworks, and a variety of browsers all work with no crashing at all. Both 2004 and 2008 crash while writing these functions on both machines. The copies of 2004 on both machines were installed from the same CD and the copies of 2008 were installed from the same DVD. We purchased several licenses but one media in each case.
I thought that the crashing while writing a formula was related to my Mac until a Windows using colleague asked me about Excel crashing while writing formulas. The only thing common to his Windows machine and my Macs is that we log onto the same network.