+ Reply to Thread
Results 1 to 4 of 4

Hours of Work Lost

  1. #1
    Forum Contributor
    Join Date
    09-25-2012
    Location
    Ventura, united States
    MS-Off Ver
    Excel 2010
    Posts
    346

    Hours of Work Lost

    Yesterday I spent several hours updating the VBA code in an excel spreadsheet. Today I go to open it and it won't open. It just says that "Excel is trying to recover my information" and "A problem caused excel to stop working correctly".

    So I guess this means that it's corrupted beyond repair.

    This happens to everyone at my office every few days on average. I'm not sure if anyone has an idea what can be done to prevent worksheets from getting corrupted. Or what exactly causes it.

    Anyway, is there any way to get into the VBA code to copy the changes I made and put them in an uncorrupted worksheet? Currently it won't even open, but the data has to be accessible somehow right?

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Hours of Work Lost

    Hi, Jiptastic,

    for the attempt to access the data: either try to load the contents/Sheets with Access or try opening the file with OpenOffice which may help.

    This happens to everyone at my office every few days on average.
    Always the same workbook or workbooks relying on a special template?

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Contributor
    Join Date
    09-25-2012
    Location
    Ventura, united States
    MS-Off Ver
    Excel 2010
    Posts
    346

    Re: Hours of Work Lost

    I don't have access or openoffice. I did get to open somehow by playing with the properties. Now I'm trying to figure out how to delete the dam thing because I accidentally made it hidden and now I can't find it.

    No common thread in the frequent corruptions. Except that we usually have VBA code in all of them, and a good amount of data.

  4. #4
    Registered User
    Join Date
    04-22-2013
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Hours of Work Lost

    On our servers at work, the individual files (unless saved on the local computer is a folder marked as such) goes to the server and is "synched" every time a person logs on with proper credentials.
    Many times my files were not available when there were synching problems.. (I started backing up locally) It is likely your files are still available, as are others, but talk to your IT department, it is a setting that can be modified.
    No, I can not suggest where the problem is, because every IT department sets up their infrastructure differently.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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