Excel 2007 and SQL Server Analysis Services 2005 Service Pack 2

re: Excel 2007 and SQL Server Analysis Services 2005 Service Pack 2

Konduru Soma Sekhar — Wed, 09 May 2007 06:57:00 GMT

I want to know more things from excel 2007 by working in microsoft office and Autocad

Off topic but worthwhile....

John Greenan — Wed, 09 May 2007 14:46:57 GMT

Hi David,

Any chance of the developer roadmap that I have been asking for since 2006? You know, should developers build .xla, .xll, com addins, automation addins or whatever Microsoft has planned????

Pretty please??

Thanks,

John

re: Excel 2007 and SQL Server Analysis Services 2005 Service Pack 2

David Gainer — Thu, 10 May 2007 23:26:02 GMT

For now, I can point you at the Excel developer portal:

http://msdn2.microsoft.com/en-us/office/aa905411.aspx

More coming later.

Dave

re: Excel 2007 and SQL Server Analysis Services 2005 Service Pack 2

Stefan KZVB — Mon, 14 May 2007 12:53:58 GMT

I've got an Excel question who probably only a Excel developer can answer right now:

Is there a way to enable print gridlines or a specific theme for every new workbook/sheet? There's no setting in Tools/Options for those things - just things like font and number of sheets for new workbooks.

I know I can set those defaults by creating some XLTXs and putting them in the XLSTART-Folder but then the user name who saved the templates will be in the newly created workbooks and the settings under Tools/Options will be ignored.

re: Excel 2007 and SQL Server Analysis Services 2005 Service Pack 2

David Gainer — Tue, 15 May 2007 21:04:56 GMT

Not sure if this helps, but Harlan Pointed this out in a previous comment:

HKCU\Software\Microsoft\Office\<version>\Excel\Options

with Options, Options3, Options5, Options6, Options95 values? [BTW, WTH is Options6 from?] Specifically, the first thing I change on new Excel installs is adding 4000H to Options3 in order to eliminate gridlines.

re: Excel 2007 and SQL Server Analysis Services 2005 Service Pack 2

Stefan KZVB — Wed, 16 May 2007 11:43:24 GMT

@David:

Adding 4000H top Options3 is a working way to hide the gridlines from the screen on new workbooks with Excel 2007. But I found no option to SHOW gridlines on the printout.

So only solution seems to be writing an addin with events and set the gridline option to print (worksheet.pagesetup.printgridlines) for new sheets.

But there really should be an easier way for administrators to specify this as default (and also a default theme)...

re: Excel 2007 and SQL Server Analysis Services 2005 Service Pack 2

marcorusso — Sun, 20 May 2007 03:10:10 GMT

David, one feature removed from SP2 ("Ability to show/hide calculated members using the checkboxes in the filter drop down menus") is very disappointing. One of my customers has been forced to reinstall SQL Server 2005 to return to Analysis Services 2005 SP1 just for this reason. His cube has many of calculated members on non-measures dimensions.

Other customers has issues too. Even the Time Intelligence Wizard (of SSAS) creates calculated members on dimension attributes and they have the same issue in Excel 2007.

I really don't understand why you did this in a SP without giving a chance to get the previous behavior.

Do you have any news about this?

Thank you

Marco Russo

re: Excel 2007 and SQL Server Analysis Services 2005 Service Pack 2

David Gainer — Mon, 21 May 2007 19:09:29 GMT

Hey Marco

Shoot me an email - thanks.

Dave

Is Microsoft serious about BI?

SQLBI - Marco Russo — Sat, 26 May 2007 15:17:22 GMT

The short answer is yes. The long answer is that Microsoft should still improve in many ways. I thought

Common Questions Around Excel 2007 OLAP PivotTables

Microsoft Excel — Wed, 06 Feb 2008 09:21:59 GMT

Today's author: Allan Folting, a program manager who works on the Excel team. I have gotten lots of questions

Common Questions Around Excel 2007 OLAP PivotTables

Noticias externas — Wed, 06 Feb 2008 09:44:21 GMT

Today's author: Allan Folting, a program manager who works on the Excel team. I have gotten lots