+ Reply to Thread
Results 1 to 2 of 2

Refresh pivottable with locked sheet

  1. #1
    Registered User
    Join Date
    02-18-2019
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    1

    Refresh pivottable with locked sheet

    Hey,

    I'm developing av calculation-program for for my company who sells electrical services.
    The basic is that we export pricefiles to a excel-file, and imports it to the calculation-program.
    We want to use this calculation-programme for our workers to make prices for our costumers.


    I've made pivottable with a button to refresh the table with and the table refreshes automatically when the sheet is opened.
    The next problem i have is that i want to lock the sheet so my co-workers don't mess up my formulas.

    The problem is that when i lock the sheet my pivottable won't update.
    I want to unlock the sheet when i click the button "refresh" and then lock it again automatically.

    Can someone help me with a formula for this?
    I've found some formulas for this on the internett, but i can't get them working.


    I'm pretty new to macros and formulas so i'm not very good at it yet.


    Hope to get some answers.
    Best regards Frank from Norway.
    Last edited by frneset; 02-18-2019 at 02:57 AM.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,910

    Re: Refresh pivottable with locked sheet

    I have not tried this myself, but I think the following will work:
    Please Login or Register  to view this content.
    Which means that the sheet is locked for the users, but not to code.

    Otherwise you will have to unprotect the sheet, do your work and then re-protect the sheet. I have done that.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Macro to refresh PivotTable.
    By TKeefe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-22-2015, 05:28 PM
  2. How to refresh only one Pivottable via VBA ????
    By Excelbat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2015, 01:42 PM
  3. [SOLVED] PivotTable auto refresh
    By ooberandy in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-05-2014, 12:20 PM
  4. Replies: 0
    Last Post: 01-07-2013, 08:39 PM
  5. PivotTable/auto refresh
    By Trainee in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-16-2011, 05:19 PM
  6. PivotTable.Refresh woes
    By JeremyR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2007, 09:04 PM
  7. Refresh Pivot in Locked Sheet?
    By Dark_Templar in forum Excel General
    Replies: 1
    Last Post: 06-05-2006, 01:37 PM

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