+ Reply to Thread
Results 1 to 3 of 3

Remote workbook usage over network messes up workbook for one user

  1. #1
    Forum Contributor
    Join Date
    03-23-2012
    Location
    Michigan
    MS-Off Ver
    MS365 Excel version 2301 (Build 16026.20238)
    Posts
    102

    Remote workbook usage over network messes up workbook for one user

    Hello,

    Our company is using Office 365 (version 2305, Build 16501.20242). Most of us work remotely and access our company's network via a program called Global Protect. We access a workbook that is saved to a shared drive. I go in and update a central workbook, and each user has their own copy of this workbook, which gets updated from the central workbook. Everyone's workbook opens and updates just fine, with the exception of one user. Everyone else has high speed internet, while this one user has a poor network connection (only around 10gbps). Opening this one user's workbook takes a very long time, and then it will update, but I always need to repair the workbook before she can use it again. If I repair that workbook before update, it then updates normally and can open and close just like the other users (which is what I normally do). But then this user will do her work during the day, and the next day, her workbook needs to be repaired again before updating.

    I'm not sure if this is actually an Excel thing with her settings that can be fixed, or likely a network issue with her connection. I'm trying to find a way to fix it, or at least a better understanding of what this internet connection is doing that might be causing this issue. Thanks for any ideas.

  2. #2
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Chicago, IL
    MS-Off Ver
    MS Office 365 ver 2202
    Posts
    1,104

    Re: Remote workbook usage over network messes up workbook for one user

    Try another router port(plug in the back), power cycle the modem, or replace the cable if the user is using a hardwired system.
    The user should also contact the ISP and describe the poor connection quality.
    *Curious what the error message reads that indicates that the file needs to be repaired.
    Pete

  3. #3
    Forum Contributor
    Join Date
    03-23-2012
    Location
    Michigan
    MS-Off Ver
    MS365 Excel version 2301 (Build 16026.20238)
    Posts
    102

    Re: Remote workbook usage over network messes up workbook for one user

    Thank you. She said the ISP did replace the modem last year, so it is fairly new. I'll have her power cycle the modem and replace the cable, and then if that doesn't help, contact the ISP.

    As for the error message, there isn't one. I can just tell by how fast the workbook opens if there are going to be problems. Everyone else can open and update in less than a minute. It takes 3-4 minutes for her workbook to just open when it gets afflicted with whatever it is. Repairing the workbook resets it back like everyone else's.

    Thank you!

+ 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. open excel workbook in same time by tow user in same network
    By mak_pj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2017, 03:58 PM
  2. Workbook usage or Database usage assistance
    By Sunshine601 in forum Excel General
    Replies: 4
    Last Post: 12-12-2013, 08:36 AM
  3. [SOLVED] Checking if another workbook is currently opened by another user on a network
    By ianpwilliams in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-05-2013, 11:24 AM
  4. User Form that submits data to a network Workbook
    By nicholnr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-07-2012, 12:16 PM
  5. Adding Code to a Remote User's Personal Workbook
    By BigBas in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-25-2008, 05:14 AM
  6. Tracking workbook user usage
    By Darren in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-13-2006, 12:55 PM
  7. [SOLVED] Is it possible to share Excel workbook with a remote user??
    By Kunal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2005, 07: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