W
William Loring
I have an Office 2004 template that our employees use to compare data
between files... It uses conditional formatting to highlight changes from
one a column in one worksheet to a column in another. I can thank the users
on this forum for getting that to work.
Anyway, we upgraded to Office 2008, in order to be able to work with XLSX
files that come from the Windows users in the office. We've now found that
this conditional formatting template is virtually unusable. Just about any
action the user takes requires watching the beach ball for 5-15 seconds.
Killing conditional formatting from the one column that uses it immediately
cures the problem. The file is not large. Perhaps several hundred rows, and
less than 20 columns. There are NO calculations in the workbook at all,
other than the one Conditional formatting column.
The machines in question are:
G5 Dual 2.3Ghz, OS 10.5.2, 2.5GB ram
G5 Dual 1.8Ghz, OS 10.4.11, 2GB ram
The conditional format formula looks like this:
Formula is: =MATCH(A1,XXX,0)>0
XXX is the label for the column on the other sheet, which is the subject of
the comparison.
Both machines show the same symptoms. The current solution is to reinstall
Excel 2004, and downconvert the XLSX files we get back to XLS. It would have
been a lot cheaper to just buy iWork for everyone, and convert that way.
I tested on a quad Intel Mac Pro, and the workbook was sluggish, but not
nearly as bad as on the G5. One would hope that a small Excel spreadsheet
would not require four 2.66Ghz processors.
Does anyone have any thoughts on this?
Regards,
William Loring
www.tirerack.com
between files... It uses conditional formatting to highlight changes from
one a column in one worksheet to a column in another. I can thank the users
on this forum for getting that to work.
Anyway, we upgraded to Office 2008, in order to be able to work with XLSX
files that come from the Windows users in the office. We've now found that
this conditional formatting template is virtually unusable. Just about any
action the user takes requires watching the beach ball for 5-15 seconds.
Killing conditional formatting from the one column that uses it immediately
cures the problem. The file is not large. Perhaps several hundred rows, and
less than 20 columns. There are NO calculations in the workbook at all,
other than the one Conditional formatting column.
The machines in question are:
G5 Dual 2.3Ghz, OS 10.5.2, 2.5GB ram
G5 Dual 1.8Ghz, OS 10.4.11, 2GB ram
The conditional format formula looks like this:
Formula is: =MATCH(A1,XXX,0)>0
XXX is the label for the column on the other sheet, which is the subject of
the comparison.
Both machines show the same symptoms. The current solution is to reinstall
Excel 2004, and downconvert the XLSX files we get back to XLS. It would have
been a lot cheaper to just buy iWork for everyone, and convert that way.
I tested on a quad Intel Mac Pro, and the workbook was sluggish, but not
nearly as bad as on the G5. One would hope that a small Excel spreadsheet
would not require four 2.66Ghz processors.
Does anyone have any thoughts on this?
Regards,
William Loring
www.tirerack.com