Things that bother me about excel, and other pet peeves

[starl]

no VBA? or it's just not installed? By default, VBA has never been included in any install I've done (I've installed standard, business and pro) - I always have to turn it on - select it manually. But it's an option in the setup...

 

[xld]

I have not come across this dummied down version of Excel without VBA, seems odd to me. Sounds like you are talking about Microsoft Works to me, which is another poriduct again.

But my other point was exactly that, Access is separate, so to talk about a Lite vresion of Excel as one without Access is ... well you can fill the rest in.

 

[TinaP]

Could the dummied down version of Excel be part of Microsoft Works?

I've run into more people that work with MS Office at work then buy a home computer following the advice of a salesperson who tells them that MS Works will do anything you need to do at home. Next thing you know, they're begging me to install Office on the home computer because Microsoft left out one or two of the most useful functions in Works.

 

[Oorang]

For my part VBA is what seperates Excel from every other product out there. There are several excellent spreadsheet product out there that I will never bother with because at the end of the limit of the program is the prgrammers imagination. And when have a robust scripting language like VBA then you are limited only by your OWN imagination not someone elses. It's pretty hard to hit the wall with Excel. You'll hit the point of diminishing returns long before you ever come into an "it can't be done situation." In fact I can't think of anytime.. ever... that I have wanted to do something in Excel and not been able to find a way to "get er done". Sometimes I have needed help, but there is always a way.
So when I heard about excel "lite" I just laughed and said "there is a product that I will not be needing".

 

[ExcelChampion]

...to have excel do this backwards drives me off the wall. What is wrong with 12D?

Might as well mention that in math, proper syntax is 2+2=4, but in Excel it is backwards, =2+2, which reults in 4. Does this bother you as well?

 

[Oorang]

...to have excel do this backwards drives me off the wall. What is wrong with 12D?

Might as well mention that in math, proper syntax is 2+2=4, but in Excel it is backwards, =2+2, which reults in 4. Does this bother you as well?

Well except that in math you anything in * = * form is an equality. And you can write an equality a = b + c or c + b = a :wink:

 

[ExcelChampion]

…em ot ko skool ti…sdrawkcab yb snaem eh tahw wonk t'nod I

 

[Oorang]

.noops on si ereht oslA ."sdrawkcab" on si ereht taht saw tniop elohw yM .esreverrts.abv htiw detsurt eb t'nac tsuj elpoep emoS *hgis*

 

[ExcelChampion]

.noops on si ereht oslA

I thought that was moops...or at least proclaimed bubble boy.

 

[Joe4]

Yes, you guys are right, I was referring to Microsoft Works that has the dummied down version of Excel with no VBA.

I ordered my computer from Dell a few years ago, and that is what comes standard with it. They advertised this great price on the whole system, but I had to upgrade (for a significant price) to get VBA and Access.

They should call it "Microsoft Works, Except for Serious Programmers"...