Is this no longer possible? I can do it in Excel 2003, but I don't see this
functionality in 2007. Thanks for a final word on this.

Hi,

This feature was removed in 2007. You can reach MS Query but the cube file
option in the last step is gone. Excel 2007 can still build pivot tables
from CUBE files.

One alternative is to keep Excel 2003 around for creating the CUBE files.

Take a look at this microsoft blog - part way down the page it discusses the
CUBE files.

http://blogs.msdn.com/excel/archive/...24/718786.aspx
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Andy" wrote:

Is this no longer possible? I can do it in Excel 2003, but I don't see this
functionality in 2007. Thanks for a final word on this.