+ Reply to Thread
Results 1 to 5 of 5

external data source security

  1. #1
    Registered User
    Join Date
    11-23-2006
    Posts
    4

    Smile external data source security

    hi all, wants to ask for some help... i have an excel pivot report, this pivot based on an external data source (sql server via odbc). i want to make this pivot to refresh everytime i open the report, so i choose the save password option for external data. and because i save the password, everybody can change the query for this pivot, is there any way that i can get automatically refresh pivot and also secure pivot?


    plss helpp..

    tx

  2. #2
    Registered User
    Join Date
    10-24-2003
    Location
    Netherlands
    MS-Off Ver
    2010
    Posts
    29
    Hi,

    I think the best way is to do this in two staps while updating via a macro.

    First you query the data via ODBC to a seperate sheet.
    Then you protect the sheet from editing (could hide it additionally)
    Then the macro should update the pivottabel.

    Good luck.

    regards,
    Arien

  3. #3
    Registered User
    Join Date
    11-23-2006
    Posts
    4
    Hi Arien, thanks for your tips. the data cannot be retrieve into another sheet , because the data is exceeded 65600 row (max row in excel).. thats why quite confusing...

  4. #4
    Registered User
    Join Date
    10-24-2003
    Location
    Netherlands
    MS-Off Ver
    2010
    Posts
    29
    Hi Jsy,

    OK. I see what you mean.
    You may want to look at the following MVP - Debra Dalgleish
    site where you will find vba code to restrict you pivottable.

    http://contextures.com/xlPivot12.html

    This may be easier.

    regards,
    Arien

  5. #5
    Registered User
    Join Date
    11-23-2006
    Posts
    4
    Hi Arien,,

    thanks for the sollution... appreciate it a lot!


    best regards,
    jsy

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1