Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Creating OLAP cubes in Excel 2007

Help! I need to create and OLAP cube using data from ms access. when i go
through creating a ms query using the wizard, the option i need is not
highlighted.
How do I activate this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default Creating OLAP cubes in Excel 2007

The OLAP Cube wizard feature has been removed from Excel 2007. If you
have an earlier verion of Excel available, you could create the cube there.

Resh wrote:
Help! I need to create and OLAP cube using data from ms access. when i go
through creating a ms query using the wizard, the option i need is not
highlighted.
How do I activate this?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Creating OLAP cubes in Excel 2007

There is no way of creating data cubes in excel 2007?

"Debra Dalgleish" wrote:

The OLAP Cube wizard feature has been removed from Excel 2007. If you
have an earlier verion of Excel available, you could create the cube there.

Resh wrote:
Help! I need to create and OLAP cube using data from ms access. when i go
through creating a ms query using the wizard, the option i need is not
highlighted.
How do I activate this?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Creating OLAP cubes in Excel 2007

Hi Resh!

I have exactly the same problem. I still was posting this topic in "Excel -
Setup", but it was seemingly the wrong newsgroup! ;)

I'm still waiting for a hint. Its a great pity, because this OLAP-Feature
has been a real benefit in previous Office-Versions.

Does there exists no more possibility?

Thanks for advice,
Marla

"Resh" wrote:

There is no way of creating data cubes in excel 2007?

"Debra Dalgleish" wrote:

The OLAP Cube wizard feature has been removed from Excel 2007. If you
have an earlier verion of Excel available, you could create the cube there.

Resh wrote:
Help! I need to create and OLAP cube using data from ms access. when i go
through creating a ms query using the wizard, the option i need is not
highlighted.
How do I activate this?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Creating OLAP cubes in Excel 2007

Yeah, what gives?

"Resh" wrote:

There is no way of creating data cubes in excel 2007?

"Debra Dalgleish" wrote:

The OLAP Cube wizard feature has been removed from Excel 2007. If you
have an earlier verion of Excel available, you could create the cube there.

Resh wrote:
Help! I need to create and OLAP cube using data from ms access. when i go
through creating a ms query using the wizard, the option i need is not
highlighted.
How do I activate this?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking multiple connections to OLAP cubes steve55 Excel Discussion (Misc queries) 0 November 27th 07 12:47 PM
GetPivotData and SQL Server OLAP cubes GetPivotMe Excel Discussion (Misc queries) 0 April 19th 07 05:34 PM
OLAP Cubes Steven Cheng Excel Discussion (Misc queries) 1 September 16th 05 05:46 AM
pivottable and OLAP cubes willcob Excel Worksheet Functions 0 May 25th 05 11:57 AM
Excel pivottable with OLAP cubes saves names, not keys jerome Excel Discussion (Misc queries) 0 April 13th 05 07:49 AM


All times are GMT +1. The time now is 06:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"