Select Multiple Items Checkbox in EXCEL 2003

Last Post 03 May 2007 09:22 AM by Rocky Raccoon. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Rocky Raccoon
New Member
New Member

--
03 May 2007 09:22 AM
I'm running AS 2005 and EXCEL 2003. I've created an EXCEL Pivot table using an OLAP cube. Everything seems to be working fine except: When I open the spreadsheet and drag a dimension from the Field List into the Filter area and click on the down arrow for a list of the dimension values the default setting for the 'Select multiple items' check box is OFF. I can change it and save the spreadsheet but I'd have to do this for each individual dimension of each cube... and we have a large number of dimensions and cubes. Does anyone know how to default the 'Select multiple items' checkbox to ON?
You are not authorized to post a reply.

Acceptable Use Policy