Missing Features in Excel 2008!?

A

Andrea

I am quite disturbed by this post. Regardless of whether the target market will ever install Office on their computer, those who do, want all the same functions as a PC user. The lack of functions is causing me to fail one of my final classes of my MBA. It is not always possible for me to access a PC and I am lacking solver, my F9 function to recalculate my random numbers, my analysis toolpack which allows me to run regressions and create histograms, run solver, etc. This is ridiculous. If you are going to create a product, it should be comparable to what you have out there. If your concern is that many people won't be using it...well, THEY aren't the ones using it.
 
J

JE McGimpsey

Andrea said:
I am quite disturbed by this post. Regardless of whether the target market
will ever install Office on their computer, those who do, want all the same
functions as a PC user. The lack of functions is causing me to fail one of my
final classes of my MBA. It is not always possible for me to access a PC and
I am lacking solver, my F9 function to recalculate my random numbers, my
analysis toolpack which allows me to run regressions and create histograms,
run solver, etc. This is ridiculous. If you are going to create a product, it
should be comparable to what you have out there. If your concern is that many
people won't be using it...well, THEY aren't the ones using it.

First - most of us here are users, so you should instead be sending
feedback via Help/Send feedback.

Second, if you read the threads, there are alternatives out there that
would allow you to perform the functions you need - XL08 isn't causing
you to fail a class.

Third, as a budding MBA, in addition to doing product research before
purchasing, I wonder if you've thought of the potential business cases
for not making MacXL and WinXL identical (and they've NEVER been
identical ever since XL was first ported from Mac to Windows).
Especially given market share, platform differences, customer
preferences, etc. That's not to say that it wouldn't be nice to have
everything you list, but there's no one "should"...
 
P

Prodlx

A question about possible missing Excel feature. In Excel 2004 when working in a column Excel would try and autofill similar information with in the column once you started typing names and numbers. Has this feature gone or do I need to turn it on?

Many thanks
 
P

pbc

Just installed Office 2008 and came to use Excel. Can't find the following that were in 2004, can any one help?
1. Print Preview command button
2. Page break view
3. How to create a chart with two vertical axes

I want to echo the lament that Page Break Preview is not available in Office 2008.

/paulc
 
J

JE McGimpsey

A question about possible missing Excel feature. In Excel 2004 when working
in a column Excel would try and autofill similar information with in the
column once you started typing names and numbers. Has this feature gone or do
I need to turn it on?

Preferences/AutoComplete, check the "Enable AutoComplete for cell
values" checkbox.
 
H

Hardy

After reading most of the comments I am deeply shocked that MS is categorizing users on basis of the computer they use.
I am a scientist and have worked many years with a PC and MS Office and never had any problems.
For 2 years I am a Mac user because I simply prefer MacOS usability over WinXP or Vista. Does this make me a different person or does it mean I have to give up my job as a scientist and become a designer because I am using Macs ??

If I am buying a programm that has the same name and is advertised to work on Mac and PC it should include the same functions.
Otherwise rename Excel 2008 in something like "Spreadsheet software like Excel with reduced functionality"
 
J

JE McGimpsey

Hardy <[email protected]> said:
If I am buying a programm that has the same name and is advertised to work on
Mac and PC it should include the same functions.
Otherwise rename Excel 2008 in something like "Spreadsheet software like
Excel with reduced functionality"

Well, since Excel was first developed and sold on the Mac platform, I'm
holding out for WinXL to be renamed...

Be that as it may, there is NO multiplatform software that is *exactly*
the same, and Office hasn't been the same on both platforms since Word,
Excel and Powerpoint were first bundled.

All software companies, if they expect to make a profit, categorize
users "on basis of the computer they use". However, many of the
differences with XL08 are due to platform differences and market share.
If Macs were a bigger share of the market, one could speculate that more
resources would have been available for including some of the features
that were dropped between XL04 and XL08. They may even have been able to
cope with the fact that Apple changed its basic architecture in the
middle of the development cycle, and everything had to be rewritten in
XCode.
 
A

Ale

If Macs were a bigger share of the market, one could speculate that more resources would have been available for including some of the features that were dropped between XL04 and XL08.

In the past there were less Mac users than today. Consequently, MS should have been much more pushed and interested in developing a "suitable" and improved version of Office, since the share of the market of Macs is now greatly increased. MS should have improved the Office for its interests!!! I think that something (or someone) did not work properly... Anyway, Office:Mac 2004 was an excellent product, regardless of its usability with the Mac Intel. I would like to remind to all of you that the transition from Office 2004 to 2008 was called "technology guarantee". So, regardless of everything, the technology of Office 2004 must have been guaranteed! And this did not happen!
Apple changed its basic architecture in the middle of the development cycle, and everything had to be rewritten in XCode.
Bla bla bla.... This sounds like an excuse to me. If I am aware that I cannot offer a good WORKING product with acceptable standards, I would not put it in the market! Two possibilities: either MS was not aware of this or they made a big mistake! Actually, there would be a third possibility.. but I do not want to think about it...

To Hardy:
I am a scientist too and I am experiencing a lot of problems with Office 2008 (in particular with Excel and Word, the latter crashing regularly). Let's take patience and use the 2004 version until something will happen in term of service pack (I hope).
Thanks and sorry.
Ale
 
J

JE McGimpsey

In the past there were less Mac users than today. Consequently, MS should
have been much more pushed and interested in developing a "suitable" and
improved version of Office, since the share of the market of Macs is now
greatly increased.

Well, Mac market share was up to 7% in December 07. That's a huge delta
for Apple, not so much for MS Corporate.

The more relevant statistics would be (1) how things looked early in the
development cycle (i.e., 2004/5) when adding resources might have made a
difference, and (2) the corporate and academic shares, and whether the
market for MacOffice is increasing as dramatically, or whether those
content to use iWork, NeoOffice, or WinOffice in emulation were/are
flattening demand. I don't know those statistics, but I'm pretty sure
that MacBU does.
Bla bla bla.... This sounds like an excuse to me.

Well of course it's an excuse. Doesn't make it invalid as a reason for
making difficult implementation choices. Changing code base for a
product that has been developed by accretion for more than 20 years is
NOT a trivial undertaking, especially when the software architecture is
fundamentally tied to then underlying operating system. Worse, of
course, is that unlike WinOffice units, MacBU isn't tightly integrated
into the OS developers.
If I am aware that I cannot offer a good WORKING product with
acceptable standards, I would not put it in the market!

And there's the rub, isn't it. "Acceptable standards" isn't an objective
criterion. We all tend to think we're typical users (or at least members
of a substantial minority). But what's acceptable to you and me (and
XL08 is NOT acceptable for *my* needs) is hardly universal.

And despite the number of folks here that are having problems, Office08
does WORK (to use your caps). I support to an organization with hundreds
of machines that are having no problems under constant use.

I don't like the choices that MacBU made, but I'll give them the benefit
of the doubt that their R&D, marketing, and management folks aren't
morons. Actually, I can do better than that - I know most of them, and
they're assuredly *not* morons.
Two possibilities: either MS was not aware of this or they made a big
mistake! Actually, there would be a third possibility.. but I do not
want to think about it...

There are far more possibilities than you've outlined. Among them is
that they put out a product that will do well enough in the market to be
both profitable and to allow them some breathing room to make
significant improvements in the next version. That's obviously what
they're hoping for.

As a business unit, to have decided to delay much further would likely
have killed off MacBU and MacOffice altogether, as Office04 slips
further out of date, and with it compatibility for the majority of users
that DON'T need VBA and add-ins. While MS corporate has loved MacBU for
its profitability, it certainly can't justify subsidizing it "just
because" - they have a duty to their shareholders after all.

Personally, I think it's a crapshoot whether MacOfficeNext ever gets to
market (at least as anything more than the equivalent of Works). The
WinOffice side isn't standing still.

My guess is that it'll depend on whether sales of Office08 are robust
enough to justify the business case for a dramatic expansion of
resources allocated to MacBU (and perhaps whether the requisite *human*
resources even exist - MacBU has had some difficulty filling positions
for quite a while, and, at least ostensibly, it hasn't been due to lack
of pay and benefits).

The market's judgment won't be out for quite a while yet. We're still
less than three months from launch - everyone who is complaining here
about Office08 is both an early adopter and savvy enough to find and use
the newsgroups/fora. That's *usually* a remarkably different demographic
than the "typical" customer.
 
P

Phillip Jones

JE said:
Well, Mac market share was up to 7% in December 07. That's a huge delta
for Apple, not so much for MS Corporate.

The more relevant statistics would be (1) how things looked early in the
development cycle (i.e., 2004/5) when adding resources might have made a
difference, and (2) the corporate and academic shares, and whether the
market for MacOffice is increasing as dramatically, or whether those
content to use iWork, NeoOffice, or WinOffice in emulation were/are
flattening demand. I don't know those statistics, but I'm pretty sure
that MacBU does.


Well of course it's an excuse. Doesn't make it invalid as a reason for
making difficult implementation choices. Changing code base for a
product that has been developed by accretion for more than 20 years is
NOT a trivial undertaking, especially when the software architecture is
fundamentally tied to then underlying operating system. Worse, of
course, is that unlike WinOffice units, MacBU isn't tightly integrated
into the OS developers.


And there's the rub, isn't it. "Acceptable standards" isn't an objective
criterion. We all tend to think we're typical users (or at least members
of a substantial minority). But what's acceptable to you and me (and
XL08 is NOT acceptable for *my* needs) is hardly universal.

And despite the number of folks here that are having problems, Office08
does WORK (to use your caps). I support to an organization with hundreds
of machines that are having no problems under constant use.

I don't like the choices that MacBU made, but I'll give them the benefit
of the doubt that their R&D, marketing, and management folks aren't
morons. Actually, I can do better than that - I know most of them, and
they're assuredly *not* morons.


There are far more possibilities than you've outlined. Among them is
that they put out a product that will do well enough in the market to be
both profitable and to allow them some breathing room to make
significant improvements in the next version. That's obviously what
they're hoping for.

As a business unit, to have decided to delay much further would likely
have killed off MacBU and MacOffice altogether, as Office04 slips
further out of date, and with it compatibility for the majority of users
that DON'T need VBA and add-ins. While MS corporate has loved MacBU for
its profitability, it certainly can't justify subsidizing it "just
because" - they have a duty to their shareholders after all.

Personally, I think it's a crapshoot whether MacOfficeNext ever gets to
market (at least as anything more than the equivalent of Works). The
WinOffice side isn't standing still.

My guess is that it'll depend on whether sales of Office08 are robust
enough to justify the business case for a dramatic expansion of
resources allocated to MacBU (and perhaps whether the requisite *human*
resources even exist - MacBU has had some difficulty filling positions
for quite a while, and, at least ostensibly, it hasn't been due to lack
of pay and benefits).

The market's judgment won't be out for quite a while yet. We're still
less than three months from launch - everyone who is complaining here
about Office08 is both an early adopter and savvy enough to find and use
the newsgroups/fora. That's *usually* a remarkably different demographic
than the "typical" customer.

Another Dark possibility to think of is now that Mac's use Intel Chips
have the ability to Run Windows Natively (with the use of Parallel's
and other products on a Mac. And MS is figuring they will just drop the
Mac version altogether because they can get more bucks out of Mac folk
buying Vista and the MC Version to get all the bells and whistles. So
why put much effort into it if they can force Mac users to Buy a retail
copy of windows for $500-600 bucks and then turn around and get
Office2007 for another $4-500 Bucks. Then if they are *forced* to use
Windows in order to get everything done They will jump ship and buy a PC
that runs directly.

--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto:p[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>
 
P

Phillip Jones

JE said:
Well, Mac market share was up to 7% in December 07. That's a huge delta
for Apple, not so much for MS Corporate.

The more relevant statistics would be (1) how things looked early in the
development cycle (i.e., 2004/5) when adding resources might have made a
difference, and (2) the corporate and academic shares, and whether the
market for MacOffice is increasing as dramatically, or whether those
content to use iWork, NeoOffice, or WinOffice in emulation were/are
flattening demand. I don't know those statistics, but I'm pretty sure
that MacBU does.


Well of course it's an excuse. Doesn't make it invalid as a reason for
making difficult implementation choices. Changing code base for a
product that has been developed by accretion for more than 20 years is
NOT a trivial undertaking, especially when the software architecture is
fundamentally tied to then underlying operating system. Worse, of
course, is that unlike WinOffice units, MacBU isn't tightly integrated
into the OS developers.


And there's the rub, isn't it. "Acceptable standards" isn't an objective
criterion. We all tend to think we're typical users (or at least members
of a substantial minority). But what's acceptable to you and me (and
XL08 is NOT acceptable for *my* needs) is hardly universal.

And despite the number of folks here that are having problems, Office08
does WORK (to use your caps). I support to an organization with hundreds
of machines that are having no problems under constant use.

I don't like the choices that MacBU made, but I'll give them the benefit
of the doubt that their R&D, marketing, and management folks aren't
morons. Actually, I can do better than that - I know most of them, and
they're assuredly *not* morons.


There are far more possibilities than you've outlined. Among them is
that they put out a product that will do well enough in the market to be
both profitable and to allow them some breathing room to make
significant improvements in the next version. That's obviously what
they're hoping for.

As a business unit, to have decided to delay much further would likely
have killed off MacBU and MacOffice altogether, as Office04 slips
further out of date, and with it compatibility for the majority of users
that DON'T need VBA and add-ins. While MS corporate has loved MacBU for
its profitability, it certainly can't justify subsidizing it "just
because" - they have a duty to their shareholders after all.

Personally, I think it's a crapshoot whether MacOfficeNext ever gets to
market (at least as anything more than the equivalent of Works). The
WinOffice side isn't standing still.

My guess is that it'll depend on whether sales of Office08 are robust
enough to justify the business case for a dramatic expansion of
resources allocated to MacBU (and perhaps whether the requisite *human*
resources even exist - MacBU has had some difficulty filling positions
for quite a while, and, at least ostensibly, it hasn't been due to lack
of pay and benefits).

The market's judgment won't be out for quite a while yet. We're still
less than three months from launch - everyone who is complaining here
about Office08 is both an early adopter and savvy enough to find and use
the newsgroups/fora. That's *usually* a remarkably different demographic
than the "typical" customer.


Of course if my theory is correct as laid out in just previous post.
Then MS can looked forward to the Federal government breaking MS up into
even smaller pieces than Ma Bell.
--
------------------------------------------------------------------------
Phillip M. Jones, CET |LIFE MEMBER: VPEA ETA-I, NESDA, ISCET, Sterling
616 Liberty Street |Who's Who. PHONE:276-632-5045, FAX:276-632-0868
Martinsville Va 24112 |[email protected], ICQ11269732, AIM pjonescet
------------------------------------------------------------------------

If it's "fixed", don't "break it"!

mailto:p[email protected]

<http://www.kimbanet.com/~pjones/default.htm>
<http://www.kimbanet.com/~pjones/90th_Birthday/index.htm>
<http://www.kimbanet.com/~pjones/Fulcher/default.html>
<http://www.kimbanet.com/~pjones/Harris/default.htm>
<http://www.kimbanet.com/~pjones/Jones/default.htm>

<http://www.vpea.org>
 
J

Jake Oliver

Does anyone know when an update will come out that will allow us to change the x axis labels for Excel 08??

It is stuck on the standard integer scale.
Is there anyway to select data for the x scale like in office 07!?!?!
 
B

Bob Greenblatt

Does anyone know when an update will come out that will allow us to change the
x axis labels for Excel 08??

It is stuck on the standard integer scale.
Is there anyway to select data for the x scale like in office 07!?!?!
No, we do not know when (or if) this will be changed. Have you looked in the
chart formatting section of the formatting palette from the tool box?
 
H

Hardy

On 4/9/08 11:21 PM, in article (e-mail address removed)9absDaxw, "Jake
Oliver" wrote:

&gt; Does anyone know when an update will come out that will allow us to change the
&gt; x axis labels for Excel 08??
&gt;
&gt; It is stuck on the standard integer scale.
&gt; Is there anyway to select data for the x scale like in office 07!?!?!
No, we do not know when (or if) this will be changed. Have you looked in the
chart formatting section of the formatting palette from the tool box?
Actually you can change the x-axis labels. It's written somewhere in this or in another post but you have to do it manually in the formula bar.
This option is not (yet) accessible via the menu/toolbox.

Edit:

I have found the following solution on another forum (after wasting more than an hour on this):

here's how to do it (explanation courtesy of Bob Greenblatt, there's no way I could have figured this out on my own!):

To specify a range of cells as the labels on the X axis, click on one of the data series in the chart (for example, click on one of the colours in a bar chart).

When you do, you will see a range appear in the floating formula bar. In my case, the range in the formula bar was:

=SERIES(Summary!$A$5,,Summary!$B$5:$R$5,3)

The space between the two commas is where the X axis labels are specified. In my case, for whatever reason, Excel didn't pick up the labels when I created the chart. I added the range of cells containing the X axis labels (cells B3 through R3) like so:

=SERIES(Summary!$A$5,Summary!$B$3:$R$3,Summary!$B$5:$R$5,3)

Problem solved!

The challenge, of course, will be to remember how to do this in a few weeks. I can't believe that MS figured that was easier than the old way (where there was a clearly-labelled field in which a user could specify the range). :eyeroll: :eyeroll: :eyeroll: :eyeroll:
 
J

Jill

Why are all the features I use in excel removed? The others I can deal with but without the customizable error bars, Excel is useless! The mere fact that I have to switch back and forth between the 2004 and 2008 makes me want to write off Microsoft all together. Something needs to be done ASAP, otherwise all of us who use charts to demonstrate data run the risk of being accused of misleading data and falsifying information.
 
P

Pat McMillan

We know how much pain this is causing and are working on a fix now. Please
set Microsoft AutoUpdate to check for updates regularly. We hope to have a
fix out for this soon.

Thanks,

Pat
 
M

Manuel_Espiritu

Until I got a MacBook Pro very recently, I was using Excel 2004. When I switched to Excel 2008, I found out that are spreadsheets that I cannot open. When I try to open some files a box comes out saying the file cannot be located or opened.

However, in the box the file name is truncated, sometime with only a few letters shown.

Strangely, this happens when the spreadsheet is in a master folder where I keep spreadsheets separated in categories. When I drag the spreadsheet out of the folder to the Desktop the file opens without any problem.

I have tried moving files back and forth between the master folder and the Desktop and it always happens this way.

What is happening? Help! :eek: :eek:
 
P

Pat McMillan

Thank you for the report. Would it be possible to answer the following:

1) Could you take a screenshot of the error alert you're getting (Command +
Shift + 4, then drag around the alert message box) and post it here or send
it to me directly ([email protected])?
2) Are the files you're trying to open on the same partition as the active
partition? Are they on a network share?
3) Can you give me the exact path where the files are stored? (that is, in
your User/Documents folder or somewhere else?

Thanks,

Pat
 
J

Jim Gordon MVP

Quoting from "(e-mail address removed)"
Until I got a MacBook Pro very recently, I was using Excel 2004. When I
switched to Excel 2008, I found out that are spreadsheets that I cannot open.
When I try to open some files a box comes out saying the file cannot be
located or opened.

However, in the box the file name is truncated, sometime with only a few
letters shown.

Strangely, this happens when the spreadsheet is in a master folder where I
keep spreadsheets separated in categories. When I drag the spreadsheet out of
the folder to the Desktop the file opens without any problem.

I have tried moving files back and forth between the master folder and the
Desktop and it always happens this way.

What is happening? Help! :eek: :eek:


Hi,

Strange things can happen if the total number of characters in the file path
goes to 200 or more.

It sounds like you are right at the limit where things start to fail. Since
moving the file to a location that has a shorter file path averts the
problem, try shortening the path name to the file and see if the problem
goes away.

-Jim
--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 
F

francescab

Office 2008 12.0.1
OS X 10.4.11

This is a drawing problem. When I am drawing lines, I can't manipulate them the way I could in Excel 2004. In fact, I can't manipulate them the way you are supposed to be able to in Office 2008.

For one, holding down the CMD key while dragging an endpoint should result in a snap-to-grid behavior. This works unless I try to position the other endpoint on the same line as the first endpoint.As I drag, the endpoint jumps all around the grid point as if there were a forcefield around it. Therefore, I can't draw, or at least resize, perfectly horizontal lines.

The second thing is using the Shift key while dragging endpoints to make lines perpendicular to the grid. That behavior is truly bizarre. When I Shift-drag an endpoint, the position of the endpoint does not track with the position of the pointer. Instead it moves proportionately to the distance the pointer travels; as I move the pointer a fraction of an inch, the endpoint jumps several inches. In addition, it exhibits the same behavior as I described above. So, even while holding down the Shift key, I can't position a line along a gridline.

What to do? I'll go back to 2004 until this gets fixed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top