Missing Features in Excel 2008!?

[JE McGimpsey]

Is it possible to get the floating dock to NOT float, and have it be
stationary?

if yes, please give directions.

if no, please just say no.

Not sure what you're referring to...

"dock" in XL usually refers to toolbars being held static against the
edge of the screen. With XL08, *some* toolbars can be "docked" in a
workbook window.

Floating is the opposite, so "floating dock" is something of an
oxymoron...

 

[ardy]

I want the formatting palette to be stationary.

 

[JE McGimpsey]

I want the formatting palette to be stationary.

Then don't move it?

As long as you have the Toolbox (of which the Formatting Palette is one
part) set far enough to the left to accommodate the widest instance (the
Object Palette, for me) *and* not docked to the right side of the
window, it shouldn't move from side to side.

Of course, it varies in height (and a bit in width) depending on what
the selection contains and which panes are open.

If you could be a bit more specific, use Help/Send Feedback to let MS
know how that would help you use the product.

 

[Maxwell]

Can someone help me? I am getting error saying not enough memory when i tried to save in Microsoft Excel 2008. How do i resolve this? Please help.

(e-mail address removed)

 

[Bo Boivie]

See the thread "Error Saving Excel 2008" below. Is it the same problem as
you have?

 

[roblake]

I have an Excel 2008 spreadsheet with a row of values, one for each minute between 9:30 AM and 3:59 PM. 390 cells. I would like to create a matching row containing the time for each cell, i.e. leftmost cell of the new matching row would contain 9:30 and the next cell to the right would contain 9:32.

I enter =a219+1 in the second cell and drag it across the row. I do NOT get 9:31 in the second cell nor any of the others to the right.

 

[Bob Greenblatt]

I have an Excel 2008 spreadsheet with a row of values, one for each minute
between 9:30 AM and 3:59 PM. 390 cells. I would like to create a matching row
containing the time for each cell, i.e. leftmost cell of the new matching row
would contain 9:30 and the next cell to the right would contain 9:32.

I enter =a219+1 in the second cell and drag it across the row. I do NOT get
9:31 in the second cell nor any of the others to the right.

That is because Excel keeps time as a fraction of a day. So by adding one,
you are adding a whole day. Since you formatted the cells as time it will
show the same time. To add one minute to a cell add 1/24/60, so your formula
will look like =a1+1/24/60.

 

[roblake]

Excel 2008 under Tiger 10.4.11.
Spreadsheet with a row of 390 cells.
Max(a277:nz277) returns a value 1.004240562

I would like to find the specific cell containing that value, but:
- the value displayed in the Max-value cell is 1.004240562 due to different precision.
- I would like to automatically locate the Max-value cell. I have tried LOCATE() but that returns N/A, perhaps due to the differing precision?

How can I do this, please?

 

[roblake]

I have a row of 390 cells of data:
1 1.000080346 1.000045404 0.99994221 1.000008155 1.000015119 1.000008664 1.00002666 0.999997767 0.999937189 0.999923123 0.999964917 1.000004996 0.999984562 1.000012659 0.999938506 1.000034953 0.999970777 0.99992335 0.999939753 0.999824465 0.999802774 0.999737768 0.999755952 0.999694054 0.99967257 0.999658889 0.999648158 0.999702798 0.99967942 0.999633184 0.999597467 0.999578669 0.999517809 0.999480875 0.999489003 0.999427154 0.99946557 0.999448079 0.999404746 0.999373537 0.999298187 0.999266807 0.999243242 0.999210752 0.999210535 0.999181947 0.999212713 0.999235382 0.999252304 0.999272948 0.999238659 0.999268115 0.999248198 0.999235012 0.999176862 0.999189609 0.999140735 0.999124645 0.999148387 0.999116807 0.999178535 0.99912426 0.999161663 0.999120136 0.99909674 0.999070402 0.999060071 0.999053844 0.999100661 0.999100019 0.999097989 0.999142057 0.999154277 0.999127783 0.999099356 0.999117828 0.999081916 0.999079223 0.999083901 0.999134629 0.999139338 0.999138318 0.999124364 0.999131785 0.999142206 0.99913122 0.999146908 0.999137215 0.999168613 0.999128349 0.999144528 0.999091073 0.99906691 0.999065565 0.999107007 0.999126963 0.999112487 0.999111822 0.9991076 0.999084702 0.999132952 0.999126135 0.999096613 0.999104975 0.999062959 0.999023139 0.999017663 0.99903067 0.999001682 0.998983029 0.99898418 0.998991266 0.999022701 0.999005593 0.999004004 0.999005376 0.998983727 0.99902603 0.99903805 0.999064975 0.99907756 0.999085865 0.999085746 0.999096589 0.999104663 0.999106234 0.999187931 0.999232949 0.999236423 0.999305708 0.999312592 0.999282623 0.999164383 0.999129906 0.999106877 0.999117561 0.9991253 0.999102222 0.999078924 0.999071181 0.999073978 0.999062942 0.999045115 0.999028396 0.999081208 0.999095096 0.99905994 0.99909202 0.99910114 0.999142059 0.999150834 0.999167325 0.999141994 0.99919007 0.999189232 0.999228632 0.999234909 0.999258049 0.99927744 0.999268823 0.999273895 0.999329278 0.999310583 0.999328952 0.999316545 0.999301261 0.999321927 0.999325705 0.999330362 0.999348986 0.999361739 0.999392203 0.999401801 0.999409942 0.999460671 0.999429777 0.99942995 0.999418406 0.999452922 0.999468613 0.999461494 0.99946182 0.999457175 0.999471784 0.999492764 0.999463555 0.999450289 0.999429073 0.999431591 0.999436022 0.999433988 0.999397634 0.999408362 0.999418004 0.999425622 0.999456125 0.999445767 0.999460627 0.99950323 0.999500452 0.999534158 0.999534469 0.999502395 0.999508164 0.999540035 0.999535926 0.999549777 0.999526082 0.99954232 0.999486947 0.999488766 0.999456802 0.999469179 0.999462072 0.999425475 0.999437106 0.999456155 0.999476088 0.999490084 0.999463693 0.999488497 0.999458935 0.999493369 0.999490431 0.999553311 0.999593934 0.999576116 0.999610581 0.999588093 0.999562924 0.999553347 0.999538319 0.999542585 0.999585717 0.999604343 0.999589918 0.999596865 0.999547282 0.999547319 0.999534236 0.999536036 0.999548138 0.999575745 0.999624223 0.999663595 0.999647193 0.999632137 0.999643786 0.999604356 0.999594884 0.999567214 0.999564687 0.999561377 0.999541527 0.999553876 0.999530243 0.999519654 0.999526466 0.999521898 0.999498087 0.999529681 0.99951039 0.999515411 0.999575907 0.999578094 0.999555363 0.999517668 0.999521444 0.99951385 0.999495213 0.999511261 0.999518411 0.99950196 0.999473812 0.999475894 0.999457613 0.999415062 0.999394216 0.999382147 0.999386141 0.999395672 0.999377596 0.99937864 0.999310824 0.99928819 0.999279546 0.999308571 0.999295463 0.999356956 0.999378101 0.999333408 0.999334429 0.999342484 0.999321202 0.999313831 0.999278553 0.999252629 0.999251148 0.999245261 0.999281163 0.999228933 0.999235828 0.999241013 0.999232008 0.99925739 0.999270438 0.999290175 0.999242969 0.999271798 0.999264291 0.999285746 0.999310125 0.999290997 0.999297087 0.999271552 0.999304845 0.99932345 0.999342237 0.999387881 0.999393934 0.999419589 0.999458838 0.999430836 0.999437495 0.999437701 0.999426128 0.999393399 0.999395355 0.999370817 0.999408458 0.999384322 0.999424748 0.999461002 0

 

[roblake]

I have a row of 390 cells of data:
1 1.000080346 1.000045404 0.99994221 1.000008155 ...

I highlight the row and select Data/Sort/Options/Sort left to right/Row 1782/OK

Nothing in that row changes!

Sorting is critical in my Excel applications.

 

[Eddie]

How do you make a graph in excel 2008?

 

[Ardy]

How do you make a graph in excel 2008?

You actually can't, this is a feature that is missing from excel 2008. No more graphs!!

 

[Ardy]

> I want the formatting palette to be stationary.

Then don't move it?

As long as you have the Toolbox (of which the Formatting Palette is one
part) set far enough to the left to accommodate the widest instance (the
Object Palette, for me) *and* not docked to the right side of the
window, it shouldn't move from side to side.

Of course, it varies in height (and a bit in width) depending on what
the selection contains and which panes are open.

If you could be a bit more specific, use Help/Send Feedback to let MS
know how that would help you use the product.

The problem is that It keeps minimizing and I would just like it to be part of the window of the document I'm working on.

 

[ajchads]

I've investigated this and agree that it's a pain, however I have a work around for you (for dates).

1. Enter the data column with years as a Date format. This will require entering in dates ending in the year you want.
2. Format the data column as a custom format of "yyyy" to display only the year.
3. Select the two columns you want and plot the chart. Excel appears to recognise dates and uses it for the horizontal axis labels/ intervals.

Hope this helps.

Bob

I tried it and it works....but that is a terrible way to solve a problem. This is a bug, because there is no way excel can know when to make some column into and x and y axis. Instead like in Windows, it should give me the option to change a series from y to x. This is why Microsoft screws up their best effort. It took 4 years to test this product?

 

[CyberTaz]

This response is not only inaccurate it is utterly false & irresponsible.

If you have nothing appropriate to offer, so be it - but please don't
intentionally submit misinformation.

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

 

[CyberTaz]

Hi Eddie -

The most direct way is to select the data you want to plot then click the
Charts button in the Elements Gallery, pick a type & style. The specifics
vary depending on how your data is arranged as well as other variables. You
might want to look at Excel Help on the keyword: chart and explore some of
the information offered there.

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

 

[ajchads]

I agree it is false to say no more charts. But I must admit having jsut spent the money to get new software, and played with charting capability in Excel 2008, it is extremely disappointing. The charts look pretty but they are inaccurate in depicting data. And having spent better part of my Sunday trying to make simple line charts work, I gave up and relied on Numbers 2008 to get the chart correctly depicted in my document (Word 2008, which thankfully let me past the Numbers chart) that I had to complete yesterday.

I think the person's response here is being tongue in cheek about the fact that charting in Excel 2008 is a tiresome exercise and for most practical purposes be impossible to use. A feature that has worked for over a decade in Excel has been badly mangled in this release. There is nothing in help that remotely explains how to select an x-axis correctly (I checked). Setting a column to read "yyyy" format, as Bob suggests, and then charting it is actually not a practical choice at all times; it is a workaround that may work sometimes. All line charts are not time series, and to assume that in a software of this complexity smacks of ignorance. This product should not have been released with such basic functionality deleted. I repeat this functionality is not new to Excel, how could it be omitted? A patch from Microsoft is desperately needed, and I hope the MVPs here can reach out to Microsoft to demonstrate to them the prioritized need for this patch.

Thanks

 

[sonic64]

UNBELIEVABLE!!! The "error bar" bug remains in the latest update!
There is still no way to customize the error bars in Excel 2008 (v. 12.0.1)

Is there any missing feature coming back?

 

[Ale]

Dear all,
I believe that this first version of Office:mac 2008 is not yet designed for serious purposes and uses. Too many missing essential features, mainly from the point of view of custom objects (such as charts and error bars: how could someone work with charts, without being able to create custom types? and what about doing black/white charts without being able to fill them with patterns?), but not only...
Maybe the last update was already planned before all our messages, thus I would allow the microsoft team working on it to allow us to work properly in the future. I would suggest to keep the Office 2004 installation until this happens and take a little bit of patience...
Anyway, one thing is sure: I followed the "Technology Guarantee" program and I can say that technology has not yet been guaranteed...

 

[Pat McMillan]

We are sorry that we weren't able to get custom error bar support into the
12.0.1 release, but we are working hard on it.

Thanks,

Pat