+ Reply to Thread
Results 1 to 4 of 4

automate update or save a shared workbook

  1. #1
    Registered User
    Join Date
    03-23-2020
    Location
    Seattle, USA
    MS-Off Ver
    365 business
    Posts
    16

    automate update or save a shared workbook

    Our department head has a shared workbook that many people have open throughout the day. He is the owner, so we can't really modify anything outside of the cells or make any macros, and he won't modify any of the settings himself.

    I'm not sure if what I'm looking for is even possible. I'd like to make a script, probably using Powershell, that'll either update or save an already open workbook. I do have a script that'll determine the PID, kill it, and re-load the file, but that is less than ideal for several reasons.

    In any case, I can't find any help searching the internet, maybe someone has run into this before?

    Excel version 2404

    Thanks,

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: automate update or save a shared workbook

    Why not have it saved on One Drive folder and sync it locally? Shared workbook feature is replaced by co-authoring. Which supports auto save, individual filter view, tracking of edited cells etc.

    No other complex script etc needed. And you have MS365 so it's supported.

    https://support.microsoft.com/en-us/...b-3024e46fb104
    "Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    03-23-2020
    Location
    Seattle, USA
    MS-Off Ver
    365 business
    Posts
    16

    Re: automate update or save a shared workbook

    As mentioned, the users have no say or control over the spreadsheet in question with regard to its properties or location.

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,973

    Re: automate update or save a shared workbook

    Then you are pretty much out of luck.

    You will need to kill all active connection to shared workbook, before you can do much with it.

+ 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. automate update or save a shared workbook
    By dbooth88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-19-2024, 09:50 AM
  2. How do I get a shared workbook to update instantly.
    By gareth7412 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-29-2022, 03:10 PM
  3. [SOLVED] Auto Save Shared Workbook and Update Display
    By Logit in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-02-2014, 02:29 AM
  4. Update shared workbook
    By selsley in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-19-2009, 01:05 PM
  5. Shared workbook cannot update object
    By ninja0059 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2008, 11:50 AM
  6. shared workbook does not automatically update
    By mike.richards in forum Excel General
    Replies: 0
    Last Post: 10-06-2008, 04:41 PM
  7. [SOLVED] Shared Workbook; Update-on-Save not working when called from code?
    By Evan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2005, 04:06 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