+ Reply to Thread
Results 1 to 3 of 3

Protect Workbook Structure settings do not save when uploaded to Sharepoint

  1. #1
    Registered User
    Join Date
    07-12-2019
    Location
    England
    MS-Off Ver
    365
    Posts
    64

    Protect Workbook Structure settings do not save when uploaded to Sharepoint

    Hi all, I have a sheet that has a main tab updated with data from sheets that I normally hide. The tab is fully locked down apart from a cell where users have a drop down tab to select a particular month. The sheet is saved on a Sharepoint accessible to around 60 volunteers of a charity.
    I am the only one who makes changes to this backing data and to avoid any unwanted changes or details being deleted I hide the information sheets and protect the entire workbook structure with a password. I then save it to sharepoint. If I am the next person to open it, the protected structure remains in place and requires a password to unhide the information sheets. If another user opens the workbook to view the information and they close it, the sharepoint site updates but it removes the protected sheet status allowing the next user to unhide and edit what should be hidden tabs.

    Any idea how I can stop this happening?

  2. #2
    Registered User
    Join Date
    05-12-2022
    Location
    WI, USA
    MS-Off Ver
    MS Excel 2016
    Posts
    1

    Re: Protect Workbook Structure settings do not save when uploaded to Sharepoint

    I am having the same issue. Protect Workbook Structure is removed after uploading to SharePoint, however the protection I have set for each individual sheet remains intact. So The cells and structure of each sheet are protected, but users are still able to move, delete, and add sheets. Not sure how much this next part matters, but to provide more info: the first time I or anyone else opens the file from Teams/SharePoint the Protect Workbook Structure is still working. The second time it's opened in SharePoint/Teams it is removed. I use MS-Office 2016 on my work computer when editing and to set the protection before saving to SharePoint, and at first thought it might be an issue with compatibility. I tested saving the document at home using the most updated version of Excel 365 then transferring the file directly to SharePoint on my work computer and ran into the same issue.

    Any help on this is greatly appreciated!

  3. #3
    Registered User
    Join Date
    03-20-2023
    Location
    USA
    MS-Off Ver
    Word
    Posts
    5

    Re: Protect Workbook Structure settings do not save when uploaded to Sharepoint

    Never met that. Sorry to hear about this error.

+ 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. Protect structure of certain sheets in a workbook
    By chaliseyp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2023, 11:36 PM
  2. VBA for Auto Email Notifications When SharePoint Files Are Updated-Uploaded
    By n_lindsey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-20-2015, 03:22 PM
  3. Replies: 0
    Last Post: 10-01-2015, 06:18 AM
  4. EDIT VBA Excel uploaded on Sharepoint
    By Saturne in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2014, 10:45 AM
  5. [SOLVED] Unprotect/Protect Workbook Structure
    By Spear86 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-28-2014, 04:26 AM
  6. Replies: 0
    Last Post: 04-02-2014, 05:02 AM
  7. Replies: 0
    Last Post: 03-12-2013, 02:33 AM

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