+ Reply to Thread
Results 1 to 3 of 3

Excel program crash when a specific user open the worksheet

  1. #1
    Registered User
    Join Date
    02-21-2017
    Location
    Norway
    MS-Off Ver
    2016 (Win10)
    Posts
    76

    Excel program crash when a specific user open the worksheet

    Hi,

    we have this workbook that was created by a staff (resigned). This workbook has a few worksheets and one of them is a breakdown of details to support a summary sheet.

    Manager A can open the workbook but he can never get into that detailed worksheet without his excel program crashing.

    We tried asking a few other users to try to open the workbook and getting into each worksheets and they are all fine. It is only manager A who is unable to get into the detailed worksheet.

    We also tried saving the file with the detailed worksheet open so that manager A can try to open up the file and view that worksheet directly. It will crash his excel program too. In the end, we have to copy the detailed sheet into another file and save it for him to access the data.

    What can be the issue here? Bugs in the original file? but it does not happen to other users. some kind of VB script to crash manager A's program if he tries to view the details??

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Excel program crash when a specific user open the worksheet

    Hi fornight,

    What version of Excel is the manager using and what version are the others using? I'd start with that. Then I'd move on to where the file is stored and is everyone using the same Environment variables to see/reach the correct filepath.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    02-21-2017
    Location
    Norway
    MS-Off Ver
    2016 (Win10)
    Posts
    76

    Re: Excel program crash when a specific user open the worksheet

    Hi, we are all using the same version 2010. Our company IT dept controls the installation of office program.

    As for where the file is stored, manager A is the owner of the file server where it is being saved so he has absolute right in the server.

    It is just a simple workbook so there is no environment variables needed to set up. We don't update the links in the file etc.

+ 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. Corrupt files> workbooks.open> excel crash
    By ayush002 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-27-2016, 03:00 PM
  2. Can seem to get Excel to go to open to a specific worksheet.
    By ijourneaux in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-03-2015, 11:13 AM
  3. Excel to open specific worksheet
    By hkbhansali in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-24-2014, 01:04 PM
  4. [SOLVED] Excel vba user form- open directly to user form not worksheet
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 04-24-2013, 05:07 PM
  5. Replies: 1
    Last Post: 08-03-2011, 10:13 AM
  6. [SOLVED] Can I program Excel to open a workbook to a default worksheet?
    By Manzie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2005, 02:00 PM
  7. [SOLVED] How can I program a message box to open when a user opens and exc.
    By Marcus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2005, 12:14 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