+ Reply to Thread
Results 1 to 2 of 2

FUlly Fuctional Pivot table controlling pivots chart on a website with protection

  1. #1
    Registered User
    Join Date
    01-06-2011
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    3

    FUlly Fuctional Pivot table controlling pivots chart on a website with protection

    Hi Guys,

    I have an excel spreadsheet with 3 pivot tables which control three pivot charts with each on separate tabs. The pivots tables are dynamic both columns and on rows. I would like to be able to put this excel sheet up on a website, with all that functionality where people can use the dynamic pivot tables and also see resultant chart while the data is protected and cannot be changed. Is this possible? Could anybody point me in the right direction please? Thanks in advance.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: FUlly Fuctional Pivot table controlling pivots chart on a website with protection

    Have a look here:

    http://technet.microsoft.com/en-us/l.../ee424405.aspx

    They're only just putting it in where I work so yet to get my hands dirty with it.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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