W
william.hooper
I have just switched to Excel 2007 and was initially really impressed:
Trying a 45,000 row sheet with some calculations in the columns and a
SUBTOTAL formula on the filtered range I am getting no occasional long
spikes in calc time due to the calc tree rebuilding which occurred
regularly with Excel 2003. Saving the workbook in the new XML format
sucks, but the new binary format kicks butt. By comparison Open Office
falls apart with complex sheets like this with terribly slow file open/
save times and memory in usage exploding to ten times Excel's level.
The 65,000 row limit and has gone at last and there is a new XLL
interface and a server side. It's a huge and impressive upgrade.
Well that's the good stuff, but then after a few minutes I got stuck
looking for, can you believe it, edit, replace!!! I searched around,
then typed edit replace into the online help but got nothing, and
finally after 20mins found the info on the web. So it's under the home
menu, then over on the far right hand side you click on find, then
click on replace... Am I the only one to think this is a dreadful
place to put edit, replace? Why is the font name over at the left and
find at the far far right? Surely we all use replace more than we
change the font in Excel? Is it me or is this literally insanity?
I see there is a tool to customize the ribbon which cost $30 at think
link:
http://pschmid.net/office2007/ribboncustomizer/starter.php
which I will have a play with as soon as I can it (getting an error in
install due to firewall).
Even then forget the days of running Excel side by side with other
apps. Squeeze the horizontal size and the Ribbon - which is the entire
UI - is utterly useless!
Anyway I am thinking Msft is going too far with these changes. We know
that a completely new looking Office could potentially drive upgrade
sales, to what extent is the Ribbon a function of this rather then
genuine usability? Here is an article about it:
http://www.willyhoops.com/Office2007Ribbon.htm
Scary....
Trying a 45,000 row sheet with some calculations in the columns and a
SUBTOTAL formula on the filtered range I am getting no occasional long
spikes in calc time due to the calc tree rebuilding which occurred
regularly with Excel 2003. Saving the workbook in the new XML format
sucks, but the new binary format kicks butt. By comparison Open Office
falls apart with complex sheets like this with terribly slow file open/
save times and memory in usage exploding to ten times Excel's level.
The 65,000 row limit and has gone at last and there is a new XLL
interface and a server side. It's a huge and impressive upgrade.
Well that's the good stuff, but then after a few minutes I got stuck
looking for, can you believe it, edit, replace!!! I searched around,
then typed edit replace into the online help but got nothing, and
finally after 20mins found the info on the web. So it's under the home
menu, then over on the far right hand side you click on find, then
click on replace... Am I the only one to think this is a dreadful
place to put edit, replace? Why is the font name over at the left and
find at the far far right? Surely we all use replace more than we
change the font in Excel? Is it me or is this literally insanity?
I see there is a tool to customize the ribbon which cost $30 at think
link:
http://pschmid.net/office2007/ribboncustomizer/starter.php
which I will have a play with as soon as I can it (getting an error in
install due to firewall).
Even then forget the days of running Excel side by side with other
apps. Squeeze the horizontal size and the Ribbon - which is the entire
UI - is utterly useless!
Anyway I am thinking Msft is going too far with these changes. We know
that a completely new looking Office could potentially drive upgrade
sales, to what extent is the Ribbon a function of this rather then
genuine usability? Here is an article about it:
http://www.willyhoops.com/Office2007Ribbon.htm
Scary....