+ Reply to Thread
Results 1 to 4 of 4

need help finding cause of a corrupted excel file which hooks up to databases

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    665

    need help finding cause of a corrupted excel file which hooks up to databases

    My workbook connects to two databases. But it is showing errors which I can't diagnose. Anyone here interested in taking a look at it? I can't post it to this thread because it has confidential info. But I can send it in a pm to anyone who has experience on this forum.

    Thanks!

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: need help finding cause of a corrupted excel file which hooks up to databases

    Hi again jrtaylor,

    It would benefit Forum Members tremendously if you could post what kind of error messages you get.

    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    665

    Re: need help finding cause of a corrupted excel file which hooks up to databases

    Thank you Winon.

    Here are the error messages... and also a screenshot of the workbook during the "hung" state. Sorry for the large image size. It looks like the key to the problem
    is in the second image. If I save the file and reopen it, the same messages appear.

    The second message refers to an xml file. I don't recognize it. It could either be due to the database queries, or a function I used in the past.



    first error.png
    error2.png
    error3.png

  4. #4
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    665

    Re: need help finding cause of a corrupted excel file which hooks up to databases

    I went to the hyperlink in the error box and located the xml file which seems to be a kind of error log. I traced it to a bug in the database. So I'll close this thread now!

+ 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. [SOLVED] Recover Damaged Excel File Corrupted By Path/File Access Error
    By SuperShaggy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2016, 07:20 AM
  2. I have a corrupted excel file.
    By CostacheI in forum Excel General
    Replies: 2
    Last Post: 02-28-2015, 12:31 PM
  3. Corrupted Excel File
    By amity10 in forum Excel General
    Replies: 0
    Last Post: 06-27-2014, 09:01 PM
  4. Corrupted excel file fix.
    By Lennnny in forum Microsoft Windows Help
    Replies: 9
    Last Post: 12-17-2013, 10:12 PM
  5. Somehow just corrupted my excel file!
    By Fred45 in forum Excel General
    Replies: 2
    Last Post: 04-28-2013, 11:06 AM
  6. Excel Corrupted File
    By jrortiz2 in forum Excel General
    Replies: 4
    Last Post: 03-28-2011, 07:09 AM
  7. [SOLVED] Excel file gets corrupted
    By Alex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2005, 11:06 PM

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