A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Pivot Table Security in Excel



 
 
Thread Tools Display Modes
  #1  
Old February 2nd, 2005, 12:01 AM
JBankson
external usenet poster
 
Posts: n/a
Default Pivot Table Security in Excel

I have an excel file that I have created that contains a pivot table.
The file is supposed to act as a kind of 'pivot table template' The
idea is that a user could download this file from a server and then
open it and use it as the basis for creating a pivot table.

I have already created the datasource in the excel file, so the
dimensions and metrics appear in the field list as soon as the file is
opened. The problem I am having is I want to be able to restrict
access to the cube and potentially some of the dimensions by user.
But, if the datasource is already created and saved in the template
file then the next time the file is opened it just uses the existing
datasource.

I would like for Excel to force the user to 'login' or use their NT
information with the datasource so that when it asks Analysis Services
for the information for the pivot table it only provides the data that
the user has access to. I can't find a way to keep excel from saving
the previous login. I've tried making sure that the Pivot
Table-Options-External Data Source-Save Password is unchecked. It
still seems to retain the data the next time I open the file.

Any ideas on how I could force the user to login when the pivot table
information is accessed?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. HDW Database Design 3 October 16th, 2004 03:42 AM
deselect multiple fields in excel pivot table AA General Discussion 1 September 23rd, 2004 12:23 AM
Pivot Table option, display as data list, repeating items down carl.fields Worksheet Functions 4 September 17th, 2004 07:57 PM
Excel Pivot Table - Calculated Items Problem BobsySpud General Discussion 1 August 2nd, 2004 08:47 PM
Pivot Table "Show All" Check Box missing in Excel 2000 Worksheet Functions 2 May 7th, 2004 03:45 PM


All times are GMT +1. The time now is 04:25 PM.


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