+ Reply to Thread
Results 1 to 8 of 8

Collaboration with macro-enable workbook opened in desktop app

  1. #1
    Registered User
    Join Date
    03-23-2012
    Location
    Michigan
    MS-Off Ver
    MS365 Excel version 2301 (Build 16026.20238)
    Posts
    99

    Collaboration with macro-enable workbook opened in desktop app

    Hi. I have a team of four people that work on a project that uses a large, macro-enabled workbook where people currently save a copy, do their business, and then I have to merge all the respective changes. I would love to be able to use OneDrive, but we have not yet been successful with getting everyone's updates to merge. Everyone has assigned rows they work on, so there isn't a risk of crossing cells or rows. But we continually get error messages that changes are not able to be saved, or they have to save a copy to their desktop or something along those lines.

    I even tried turning off the autosync setting in my OneDrive (where I saved the workbook for us to test), and everyone also turned off autosave. We still were not successful.

    Has anyone had any success with this? If so, could you share advice on how to proceed, please? Thank you!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Collaboration with macro-enable workbook opened in desktop app

    We share and collaborate on macro-enabled workbooks via SharePoint, which is the business version of OneDrive. As long as collaborators open the workbook in the desktop app and not the browser, it works fine. You need auto save on.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    03-23-2012
    Location
    Michigan
    MS-Off Ver
    MS365 Excel version 2301 (Build 16026.20238)
    Posts
    99

    Re: Collaboration with macro-enable workbook opened in desktop app

    Ah! To make sure I've got this right, you save your workbook to a document library in SharePoint Online, is that correct? Thank you so much for replying! Our process lends itself perfectly to the single workbook collaboration, so if we can get this working, it would be awesome! Thank you!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Collaboration with macro-enable workbook opened in desktop app

    Yes - if by "library" you mean what SharePoint calls a "site".

    The only issues we've had is when people ignore the instructions to open the workbook in the desktop app. This is often because they don't understand the distinction, so you have to give very specific instructions. Macros won't work in the browser interface, so any validation you have set using VBA can be overridden there, so you need to ensure that your collaborators all understand how to open the workbook in the desktop app.

  5. #5
    Registered User
    Join Date
    03-23-2012
    Location
    Michigan
    MS-Off Ver
    MS365 Excel version 2301 (Build 16026.20238)
    Posts
    99

    Re: Collaboration with macro-enable workbook opened in desktop app

    Hi. Yes, we've been trying with opening in the desktop app. It just has not been successful for us using OneDrive or Teams. Everyone had the workbook open in the desktop app, made changes, but then the connection broke or blocked and people were asked to make a copy. That defeats the purpose. I appreciate your help. I've got a meeting set up for Monday to test this with my team. Thank you!

  6. #6
    Registered User
    Join Date
    03-23-2012
    Location
    Michigan
    MS-Off Ver
    MS365 Excel version 2301 (Build 16026.20238)
    Posts
    99

    Re: Collaboration with macro-enable workbook opened in desktop app

    Hi. We tried a different method using just a .xlsx workbook, and that of course worked just fine. However, the main workbook is a .xlsm where users have a column where the leave notes on their assigned records.
    Since using the central .xlsm workbook didn't work, I'm thinking about using a .xlsx workbook, and then create a macro that pushes and pulls notes from the user's .xlsm workbook to the central Notes.xlsx workbook.
    The problem I'm encountering with that is being able to open the Notes.xlsx workbook in edit mode from SharePoint Online. That's a different issue, though, and I can post a new question (although I've searched and
    tried many different possible ways with no success.

    I mainly just wanted to post back with our results. I appreciate all of your help. Thank you!

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Collaboration with macro-enable workbook opened in desktop app

    Thanks for letting us know.

    As I said, we use shared .xlsm files on SharePoint (fully editable) and have no issues.

  8. #8
    Registered User
    Join Date
    03-23-2012
    Location
    Michigan
    MS-Off Ver
    MS365 Excel version 2301 (Build 16026.20238)
    Posts
    99

    Re: Collaboration with macro-enable workbook opened in desktop app

    Maybe it's the density of macros in our workbook. there are a lot of them, both in regular modules and within worksheets. I would truly love for this to work. Which version of SharePoint are you using? We have SharePoint Online.

+ 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. Strange error in a workbook macro when a workbook unrelated is opened.
    By PaulM100 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-02-2019, 11:09 AM
  2. Enable editing when workbook is opened
    By mb1824 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2018, 07:45 PM
  3. Replies: 0
    Last Post: 04-07-2014, 02:00 PM
  4. Use a macro to extract cell data from opened workbook to new opened workbook
    By BrianTFC in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-26-2014, 01:35 PM
  5. Replies: 0
    Last Post: 04-26-2013, 03:40 AM
  6. How to enable macros when a file is opened from another macro
    By aspicuelta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2011, 12:32 PM
  7. [SOLVED] Save Excel workbook to Desktop Using a Macro
    By Marvin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-11-2006, 02:25 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