Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JBankson
 
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?

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
Can't group pivot table items by month in Excel scott_ensley Excel Discussion (Misc queries) 1 February 1st 05 09:41 PM
Excel XP Pivot Table in Excel 2000 bsantona Excel Discussion (Misc queries) 0 January 20th 05 07:37 PM
convert excel list to pivot table GI Excel Discussion (Misc queries) 0 December 6th 04 07:45 PM
Pivot table : Excel cannot complete this task with available resou Julie Excel Worksheet Functions 0 November 5th 04 05:09 AM
Referring to Pivot Table in Excel 2003 Martin_xx Excel Worksheet Functions 1 November 2nd 04 10:45 PM


All times are GMT +1. The time now is 06:34 AM.

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

About Us

"It's about Microsoft Excel"