Missing Features in Excel 2008!?

[Becksvl]

Data Analysis is missing can somebody point me out on where to download the add-ins

 

[Becksvl]

This is really a problem and inexcusable. What's the point of using Excel
without this? Why take a step backwards?

As someone who uses XL every day, and *never* used page break preview,
and doesn't mind using the system's print preview feature, I'd say the
point of using XL is "to do work".

For my needs, and for most of my clients, we're not affected by the
removals, which were almost certainly done as part of the effort to ship
Office 2008 sometime this decade.

However, your needs obviously are different, so make sure you tell *MS*
by using Help/Send Feedback. Make sure you give a justification - how
much your company would use it; whether you'd pay more for an upgrade if
those features were included again. That could help MacBU prioritize it
against other feature requests.
[/QUOTE]

 

[Bob Greenblatt]

There is NO Data Analysis add-in for Excel 2008. All the functions are
directly available in Excel. The Analysis wizards are missing because there
is no VBA for Excel 2008.

 

[David Bernick]

Apparently microsoft decided to ship Excel 2008 without VBA on the mac. This means that the Analysis toolkit is also absent, along with solver. The "fix" for this problem is to not use Excel 2008, or in the case of solver, you can use a non VBA variant that is slow and not well integrated with Excel.

This is in fact the fix that Microsoft suggests. Now, if you were using the Windows version of the product, then you wouldn't have this problem.

It's a bit hard to see how this major regression isn't being fixed or even taken seriously.

So. I think I have been polite and truthful, and maybe even civil. The truth is, I want my money back but I didn't discover this defect within the 45 day period that microsoft gives its users to find out if the latest version of a product was actually as good as its predecessor.

 

[David Bernick]

the >> add-ins There is NO Data Analysis add-in for Excel 2008. All
the functions are directly available in Excel. The Analysis wizards are
missing because there is no VBA for Excel 2008.





-- Bob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom





Dearest Mr. Greenblatt -




I just tried to find the "histogram" function, which used to be part of the Analysis toolkit. I do not seem to find it "directly available in Excel". I just now went to look for the "Correlation" function (also use to be in Analysis toolkit) and it does not seem to be "directly available in Excel" either. Am I looking in the wrong place, or .. maybe you were referring to Excel 2004?

 

[CyberTaz]

Hi David;

I think the confusion is a matter of terminology What you are looking
for - the Add-Ins - are *not* functions. They are *features* based on VBA
which provided convenient dialog interfaces for plugging in values that were
fed to the appropriate functions. What Bob G is saying is that the functions
are available in Excel 2008 but the "wizard-like" interfaces don't work in
this version because of the lack of VBA support.

IOW, you can get the same results but you have to put the proper expressions
together yourself. A few of the add-ins have been replicated in other ways
but whether they encompass what you need I have no idea. A search of the
group as well as some Googling may locate useful alternatives.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Bob Greenblatt]

Apparently microsoft decided to ship Excel 2008 without VBA on the mac. This
means that the Analysis toolkit is also absent, along with solver. The "fix"
for this problem is to not use Excel 2008, or in the case of solver, you can
use a non VBA variant that is slow and not well integrated with Excel.

This is in fact the fix that Microsoft suggests. Now, if you were using the
Windows version of the product, then you wouldn't have this problem.

It's a bit hard to see how this major regression isn't being fixed or even
taken seriously.

So. I think I have been polite and truthful, and maybe even civil. The truth
is, I want my money back but I didn't discover this defect within the 45 day
period that microsoft gives its users to find out if the latest version of a
product was actually as good as its predecessor.

Just a few comments in addition to Cybertaz's:
Microsoft's decision regarding the removal of VBA was announced publically
MONTHS before Office 2008 was released. So, it should be no surprise to you
that it is not there.

Solver's omission has been rectified. If you are unhappy with the
implementation, so be it, but it works just fine.

The "major regression" has been taken VERY seriously by Microsoft. That's
why there is now a solver for Excel 2008, and why Microsoft has announced
that VBA will return in the next version of Office.

If you want your money back, I'm sure the vendor where you purchased Office
can arrange that.

 

[Phillip Jones, C.E.T.]

Oh, it being taken quite seriously after the academic Community spoke up
Loud and clear. Figuratively if not literal whopping them upside the
ears for removing it. MS was unaware that that the academic community
used Mac's as much as they do. So It will be back in version 2010 (or
11, or 12) or when ever it comes out. Its promised. For some reason they
found changing the VBA code model over to the new system is too complex
and would have hurt chances of getting 2008 out on time. From all the
people That fussed they would have been better served to explained why
VBA would cause the drag down and went ahead and pushed back the release.

I don't use VBA or Solver. But the only advantage I see is the new built
in PDF converter bypass the problem with Page and section breaks causing
multiple pdfs to be created for years.

That alone is worth the upgrade if you use PDF's

Apparently microsoft decided to ship Excel 2008 without VBA on the mac. This means that the Analysis toolkit is also absent, along with solver. The "fix" for this problem is to not use Excel 2008, or in the case of solver, you can use a non VBA variant that is slow and not well integrated with Excel.

This is in fact the fix that Microsoft suggests. Now, if you were using the Windows version of the product, then you wouldn't have this problem.

It's a bit hard to see how this major regression isn't being fixed or even taken seriously.

So. I think I have been polite and truthful, and maybe even civil. The truth is, I want my money back but I didn't discover this defect within the 45 day period that microsoft gives its users to find out if the latest version of a product was actually as good as its predecessor.

--
------------------------------------------------------------------------
Phillip M. Jones, CET mailto[email protected]
If it's "fixed", don't "break it"! http://www.vpea.org
http://www.kimbanet.com/~pjones/default.htm
G4-500 Mac 1.5 GB RAM OSX.3.9 G4-1.67 GB PowerBook 17" 2GB RAM OSX.4.11
------------------------------------------------------------------------

 

[John]

I cannot believe that Excel 2008 no longer supports VB macros. Like them
or not they were essential to automating serious spreadsheets. I and I
suspect many other serious users will never upgrade until support for
VB macros is reinstated. Do you really expect me to rewrite all my spreadsheets
using Apple's scripting??




Richard: It is time that Apple and community elevates iWorks to a professional level. Microsoft is fearful of Apple progress, and wants to hold us captive.

Here are some suggestions:

1. NeoOffice. Still clunky but great future.
2. I am working with Quckeys and having some success. I wish I were further along, but maybe you can give this a try. Looks promising.

 

[Phillip Jones, C.E.T.]

I cannot believe that Excel 2008 no longer supports VB macros. Like them
or not they were essential to automating serious spreadsheets. I and I
suspect many other serious users will never upgrade until support for
VB macros is reinstated. Do you really expect me to rewrite all my spreadsheets
using Apple's scripting??




Richard: It is time that Apple and community elevates iWorks to a professional level. Microsoft is fearful of Apple progress, and wants to hold us captive.

Here are some suggestions:

1. NeoOffice. Still clunky but great future.
2. I am working with Quckeys and having some success. I wish I were further along, but maybe you can give this a try. Looks promising.

John,

can You explain the differences between QuickKeys and *TypeIt4Me*?
I've been using the latter for years. I even you it to auto correct
misspellings of certain words I am constantly transposing letters in. or
typing a lower case "i" instead of the uppercase "I".
--
------------------------------------------------------------------------
Phillip M. Jones, CET mailto[email protected]
If it's "fixed", don't "break it"! http://www.vpea.org
http://www.kimbanet.com/~pjones/default.htm
G4-500 Mac 1.5 GB RAM OSX.3.9 G4-1.67 GB PowerBook 17" 2GB RAM OSX.4.11
------------------------------------------------------------------------

 

[Phillip Jones, C.E.T.]

John,

*Can* You explain the differences between QuickKeys and *TypeIt4Me*? I've
been using the latter for years. I even *use* it to auto correct
misspellings of certain words I am constantly transposing letters in. *Or*
typing a lower case "i" instead of the uppercase "I".

Now if I could just find a good proofreader tool for SeaMonkey I'd be
all set. I correct and bold face corrections above. :-(
--
------------------------------------------------------------------------
Phillip M. Jones, CET mailto[email protected]
If it's "fixed", don't "break it"! http://www.vpea.org
http://www.kimbanet.com/~pjones/default.htm
G4-500 Mac 1.5 GB RAM OSX.3.9 G4-1.67 GB PowerBook 17" 2GB RAM OSX.4.11
------------------------------------------------------------------------