+ Reply to Thread
Results 1 to 2 of 2

Excel template on SharePoint Team site now opening "locked for editing"

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Excel template on SharePoint Team site now opening "locked for editing"

    My company is using SharePoint Team Site and I have been opening templates from my local SharePoint synced folder for over a year.
    3 days ago, all the templates we use open "locked for editing by another user" even though only 2 of us access the files and neither of us have them open.
    The same scenario happens when using SharePoint web links. Moving the files to other folders makes no difference.
    The files, moved locally, open normally.
    Does anyone here access templates stored on SharePoint? Your insight would be greatly appreciated
    Since the template only "locked" using my macro, I thought I should post it in case it leads somewhere.
    Please Login or Register  to view this content.
    Last edited by VBA_Novice_VBA; 08-09-2019 at 07:24 PM.

  2. #2
    Registered User
    Join Date
    06-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Excel template on SharePoint Team site now opening "locked for editing"

    I found the cure myself. It was as simple as adding a change directory statement before opening the template and changing the way I opened the template to "Workbooks.Add Template".

    This macro locates the most recent version of an Excel template "xltx" file in a folder and opens a copy. It does work well with SharePoint shared synced folders.

    Please Login or Register  to view this content.
    Last edited by VBA_Novice_VBA; 08-10-2019 at 03:53 PM. Reason: Found the cure

+ 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. Replies: 3
    Last Post: 04-10-2019, 09:30 AM
  2. Replies: 0
    Last Post: 03-28-2019, 10:27 AM
  3. Excel sheet is locked for editing by "another user"
    By akadoggs in forum Excel General
    Replies: 5
    Last Post: 10-21-2014, 06:04 PM
  4. Opening SharePoint file with VBA - disable SharePoint "Contacting the server" message
    By kopite2002 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-22-2013, 01:56 AM
  5. Replies: 0
    Last Post: 03-05-2013, 07:22 PM
  6. "PERSONAL.XLSB is locked for editing" notice when opening second instance of excel
    By csch123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2012, 02:06 AM
  7. Replies: 1
    Last Post: 10-29-2009, 01:37 PM

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