Excel 2010

[starl]

I thought 2010 was released corporate or something.. not general public, but there's been some kind of release. Plus, 2010 books are out - if you have a safari account, you can see the rough drafts..
so aren't the nda's a bit pass? course, i know nothing about 'em.

 

[RoryA]

It's on MSDN and Technet, so I don't think we're under NDA anymore.

 

[Greg Truby]

It's on MSDN and Technet, so I don't think we're under NDA anymore.

I was at a TechNet event yesterday for the Launch of 2010 and they were passing out evaluation copies of Office Pro 2010, Project 2010 & Visio 2010. Obviously everyone at that meeting was not under NDA, so I don't see how what would still be the case.

When using a slicer in a pivot, should it appear on my printed page? I'm sure the answer is yes, but I get a blank space.

Marc

The default would be to print. However, you can right-click the slicer and pick Size and Properties... and in the Properties tab there is a checkbox for Print Object that might, somehow be unchecked. [I'm assuming you've done the obvious and confirmed that the PrintRange includes the slicer.]

 

[RoryA]

Yeah, but we were under NDA for the Beta/Tech Preview, when other participants weren't, IIRC?

 

[starl]

oh - Bill did a webinar on what's new in 2010, and he's part of the boy's club.... i'd say the nda is finished.

heck.. how are we to advertise our books if we can't talk about them?!
cause my newest one rocks (sorry, I just HAD to add that!)

 

[Greg Truby]

...he's part of the boy's club...

I shall leave it to Von Pookie to supply an appropriate degree of umbrage for this quip.

...cause my newest one rocks

Parece que no hay disponibles...

http://www.amazon.com/Excel-Macros-...=sr_1_6?ie=UTF8&s=books&qid=1275682924&sr=1-6

 

[T. Valko]

So where can I find a list of any new worksheet functions?

Surely they've added MINIF(S), MAXIF(S)?

What else?

What about some new robust functions for filters?

Is there a new efficient function for counting/looking up/extracting uniques?

 

[DonkeyOte]

http://www.software.maninweb.de/news/175/279/The-new-functions-in-Excel-2010/d,news_details.html

I think the INTL versions of the working day calcs will prove esp. useful as will the RANK extensions.

Hopefully there will be more... I don't have 2010 myself unfortunately.

 

[T. Valko]

We just had one of those "endless" threads at the new MS Answers forums dealing with WORKDAY that included weekends. Some of the suggested formulas are really complex (not to mention long!). Looks like that new WORKDAY.INTL function will come in handy!

I wonder what that new AGGREGATE function does? It sounds promising!

 

[DonkeyOte]

We just had one of those "endless" threads at the new MS Answers forums dealing with WORKDAY that included weekends. Some of the suggested formulas are really complex (not to mention long!). Looks like that new WORKDAY.INTL function will come in handy!

No one tell Barry H