Excel 2007 Consolidated PivotTable

[Mac]

It seems that Excel 2007 does not produce pivottables from multiple
consolidation ranges as in past versions. I find them extremely useful in
combining budgetary data. Have I missed something?

Any assistance on this issue would be appreciated.

=Mac=

 

[CyberTaz]

You've definitely missed the right newsgroup this one is for Mac Excel. I
don't believe there is a dedicated group for the '07 Beta, but you might
want to start here:

http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.pu
blic.excel.misc&lang=en&cr=US

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

 

[ShaneDevenshire]

Hi,

Is this in MAC 2007 or PC 2007?

 

[JE McGimpsey]

Is this in MAC 2007 or PC 2007?

It can only be PC. Mac's (not MAC'S) next version is 2008.

 

[JE McGimpsey]

By the way how do you access the menu from the keyboard on the mac?

Turn on Keyboard Navigation (System Preferences/Keyboard &
Mouse/Keyboard Shortcuts, check the Keyboard Navigation checkbox). Note
that it doesn't work the same way, though -that turns navigation on
system-wide, and you need to use the arrow keys to navigate across the
menu.