You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
I have recently been talking to some customers (both at a conference and on a series of visits last week), and a number of them asked about Excel 2007 and Microsoft SQL Server Analysis Services – specifically, what changes in Excel when Services 2005 Service Pack 2 (or newer) is installed on the server. There are a number of differences manifested in Excel 2007, so I thought I would list them here for folks.
First, some additional functionality is enabled in Excel. Specifically, the following filter types are enabled in PivotTables connected to Analysis Services:
You might also notice that a couple of options are no longer available with Analysis Services 2005 Service Pack 2:
The reason behind these two changes is the way that Excel creates queries when Analysis Services has Service Pack 2 installed – Excel generates slightly different queries for the new filtering features, and these two features are not available with the query constructs Excel uses.
Comments: (8) Collapse
I want to know more things from excel 2007 by working in microsoft office and Autocad
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
For now, I can point you at the Excel developer portal:
msdn2.microsoft.com/.../aa905411.aspx
More coming later.
Dave
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.
Not sure if this helps, but Harlan Pointed this out in a previous comment:
HKCU\Software\Microsoft\Office\\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.
@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)...
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
Hey Marco
Shoot me an email - thanks.
Comments: (loading) Collapse