Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default XLS 2007 pivoting off SSAS 2005 odd behavior

My team is using Excel 2007 to Pivot off an Analysis Services 2005 data cube,
and we're getting some odd & inconsistent behavior between users.

When we go into the XLS Pivot Options, some of the options are grayed out
and disabled. The odd thing is that the disabled ones are different for each
user. I can't reach Display tab "Show properties in tooltips". My
co-developer has this, but can't reach Totals & Filters "Subtotal filtered
page items" or Display "Display item labels when no fields are in the
values area".

We discovered this while investigating a crashing problem that seems to be
related to those "properties in tooltips". The solution to avoid crashing is
to go into the PivotTable Options and turn off the option, but that's not
available to all of us. All users involved here are Administrators, so we
don't think it's a matter of security or roles.

Anyone have an idea of what might cause this? Is there some general option
in Excel, Office, a particular Data Connection (or maybe even .NET or
Windows) that might impact which PivotTable Options a person has access to?
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
Excel 2007 strange behavior on two computer kurlisue Excel Discussion (Misc queries) 1 April 21st 08 09:21 PM
change 12/5/2007 to 12/1/2005 Alan Calan Excel Discussion (Misc queries) 5 November 4th 07 01:46 AM
How do I update the 2005 attendance calendar to 2007? mtc Excel Worksheet Functions 4 September 26th 07 09:50 PM
Access to Excel 2007 curious behavior artificial Excel Discussion (Misc queries) 0 February 6th 07 05:41 PM


All times are GMT +1. The time now is 09:57 AM.

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

About Us

"It's about Microsoft Excel"