Page 5 of 6 FirstFirst ... 3456 LastLast
Results 41 to 50 of 53

Excel found unreadable content in "".

This is a discussion on Excel found unreadable content in "". within the Excel Questions forums, part of the Question Forums category; Originally Posted by StreetMike At this point, I have still not found a solution and continue to have the issue. ...

  1. #41
    MLF
    MLF is offline
    New Member
    Join Date
    Sep 2010
    Posts
    2

    Default Re: Excel found unreadable content in "".

    Quote Originally Posted by StreetMike View Post
    At this point, I have still not found a solution and continue to have the issue.

    At least it's nice to know I am not alone.
    Frustrating, isn't it?
    The "hot-fix" number '314 (http://support.microsoft.com/kb/983314/en-us) did *not* work for my problem.
    My problem is closely tied to using the ctrl+alt+shift+f9 to force the rebuild of the calculation dependence chain. I have to do something, as the chain gets corrupted several times a year and gives no symptoms other than wrong calculation results.
    Anyway, the work-around to prevent the problem, as another person mentioned, is to replace the equal signs.

    Microsoft has recommended that in the past:
    http://support.microsoft.com/service.../WCD091801.ppt
    (Although they also have liked the "new" feature: ctrl+alt+shift+f9)

    Because I'm lazy and will have to do this frequently, I just tossed together a couple of short macros.

    To convert it...
    Sub convertEquationsToText()

    For i = 1 To Sheets.Count
    Debug.Print Sheets(i).Name

    If Sheets(i).Visible = xlSheetVisible Then
    Sheets(i).Select
    Cells.Replace What:="=", Replacement:="##mlfTrouble##", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
    End If

    Next i

    End Sub


    And here's converting it back again...
    Sub convertTextToEquations()

    For i = 1 To Sheets.Count
    Debug.Print Sheets(i).Name

    If Sheets(i).Visible = xlSheetVisible Then
    Sheets(i).Select

    Cells.Replace What:="##mlfTrouble##", Replacement:="=", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False

    End If

    Next i

    End Sub

    Note that I'm only changing the visible sheets. That works fine for me, but you can use additional coding to convert hidden and very hidden sheets if you need to.
    Last edited by MLF; Sep 27th, 2010 at 05:02 PM. Reason: additional caveat

  2. #42
    Board Regular
    Join Date
    Oct 2006
    Posts
    1,143

    Default Re: Excel found unreadable content in "".

    I had this problem and it was due to some sorting vba i was using. I posted an example of my workbook at: http://www.excelforum.com/excel-prog...ng-2007-a.html

    Not exactly sure why this worked but I fixed the problem by changing the sub routine code found in the "UtilityMod" module. I changed it from:
    Code:
    Public Function AutoSortTable(ByVal sortRng As Range, ByVal ws As Worksheet, ByVal headVal As Boolean, ByVal sortOne As Long, ByVal sortTwo As Long)
        sortRng.Sort Key1:=ws.Cells(sortRng.Resize(1, 1).Row, sortRng.Resize(1, 1).Column + sortOne), Order1:=xlAscending, _
                     Key2:=ws.Cells(sortRng.Resize(1, 1).Row, sortRng.Resize(1, 1).Column + sortTwo), Order2:=xlAscending, Header:=headVal
    End Function
    To:

    Code:
    Public Function AutoSortTable(ByVal sortRng As Range, ByVal ws As Worksheet, ByVal headVal As Boolean, ByVal sortOne As Long, ByVal sortTwo As Long)
        Dim sortKey1 As Range, sortKey2 As Range
        Set sortKey1 = ws.Cells(sortRng.Resize(1, 1).Row, sortRng.Resize(1, 1).Column + sortOne)
        Set sortKey2 = ws.Cells(sortRng.Resize(1, 1).Row, sortRng.Resize(1, 1).Column + sortTwo)
        If sortKey1 = sortKey2 Then
            sortRng.Sort Key1:=sortKey1, Order1:=xlAscending, Header:=headVal
        Else
            sortRng.Sort Key1:=sortKey1, Order1:=xlAscending, _
                         Key2:=sortKey2, Order2:=xlAscending, Header:=headVal
        End If
    End Function
    I got the idea that maybe the code was passing a duplicate key from reading the older posts on page 3. Once I changed the code, ran the macros, and saved the workbook the error went away. Interestingly enough, I tried it without doing the if statement, only setting the sortKey variables and passing those into the sort method, but that didn't work. For what ever reason it need the if statement.
    Erock 24

    Use it up, wear it out, make it do, or do without.

  3. #43
    New Member
    Join Date
    Nov 2010
    Posts
    1

    Default Re: Excel found unreadable content in "".

    I had the same problem with unreadable data. I found an easy solution for the sort key issue. Make sure that you clear the sortfields before saving.

    ActiveSheet.Sort.SortFields.Clear

    It can be maddening Hope it helps.

  4. #44
    New Member
    Join Date
    Nov 2010
    Posts
    1

    Thumbs up Re: Excel found unreadable content in "".

    I read through many pages before stumbling on to your response about unsorting... It worked!

    I was running a macro to sort a table:


    Code:
    Sub Subsystem_Change()
        With Application
            .ScreenUpdating = False
        End With
     
        ActiveWorkbook.Worksheets("Data").ListObjects("TableNC").Sort.SortFields.Add _
            Key:=Range("BB4"), SortOn:=xlSortOnValues, Order:=xlDescending, _
            DataOption:=xlSortNormal
     
        With ActiveWorkbook.Worksheets("Data").ListObjects("TableNC").Sort
            .Header = xlYes
            .MatchCase = False
            .Orientation = xlTopToBottom
            .SortMethod = xlPinYin
            .Apply
        End With
        With Application
            .ScreenUpdating = True
        End With
    End Sub
    I added the following at the end and resaved:

    Code:
        ActiveWorkbook.Worksheets("Data").ListObjects("TableNC").Sort.SortFields.Clear

    Success!

    Thank you so much!
    Mac

  5. #45
    New Member
    Join Date
    Apr 2011
    Posts
    1

    Default Re: Excel found unreadable content in "".

    Thanks to all for your great suggestions to this frustrating problem.

    I was having problems when reloading complex reports personalized for many end-users. Recreating files every time the issue surfaced was not going to be feasible, nor was requiring hundreds of end-users to make office or system changes.

    Fortunately, I was able to resolve the issue by saving my .xlsx files as .xlsm (even though they had no macros). When they were re-opened they were 'clean' and could be saved as .xlsx again. When I encounter the issue in an .xlsm, I will certainly try clearing the sort fields.

    Thank you!

  6. #46
    Board Regular hatman's Avatar
    Join Date
    Apr 2005
    Location
    Palmer, MA
    Posts
    2,606

    Default Re: Excel found unreadable content in "".

    One of my co-workers asked my help on a file of his that has suddenly started exhibiting this problem. When I use the Recover option, it does not indicate what (if anything) was repaired. There is one worksheet of values, no worksheet formulas at all. Several Class Modules, standard Code modules and Userforms, as well as a Custom User INterface. I eliminated ALL vba components, and the problem went away. When I import any of these components into a fresh new workbook, the problem transfers to that workbook. If I import any of these components back into the original workbook, the problem returns. If I simply add a new empty VBA component to the original workbook (not importing the originally exported stuff) the problem returns. If I backsave the file to 2003, the problem is still there if the VBA stuff is still in it. I have tried every combination of removing teh VBA components, saving to xlsx, xl 2003, xl 2007, xl 2010, then re-adding ANY VBA compnent to teh file, and the problem returns. Not sure what's going on, but I', still poking at it. Any additional advice would be helpful.
    (XL2010 on Windows 7 Professional SP 1)

    H0mogenized pasteurized milk from confinement animals, and butter, cheeses, and yogurts made from such milk, may look the same and carry the same name, but the inference that they are the same as [raw unpasteurized milk from pasture-fed cows] is part of the insidious deception that has been perpetrated on (us) the consumers of industrialized food.

    -Ron Schmid, "The Untold Story of Milk"

  7. #47
    Board Regular hatman's Avatar
    Join Date
    Apr 2005
    Location
    Palmer, MA
    Posts
    2,606

    Default Re: Excel found unreadable content in "".

    This has become very vexing and confusing to me. I'm not sure if this latest finding is related to root cause, or just some sidebar oddity.

    After realizing that I could open the file without error if I waited at least a few minutes after closing teh session, I tried the following:

    I started a new, blank workbook in a new fresh session of Excel. I inserted a blank code module, and saved it as an xlsm file. Then I closed the session, and used Windows Explorer to open the file, allowing the OS to autoinstantiate a new session of Excel. I then proceeded to close out of Excel without making any changes to the file or re-saving it, and re-open the file through Windows Explorer. At the second or third cycle, I started getting the exact same error message indicating that theere was corruption in the file. Not sure HOW corruption could occur if I have closed teh file without making changes or saving it. I discovered through experimentation that if I waited at least a few minutes before re-openning teh file, the error did not occur. I also found if I closed teh file without ecitting teh Excel session, and then re-opened teh file, no matter how short the cycle time, the error would not occur.

    My conclusion is that there is not actually anything wrong with the file, but rather there may be some helper or cache files that get built based on VBA library inclusion that require several seconds to be deleted from the temp drive (at my company, the temp folder is actually located on a share network drive) and when a new session is instantiated before these files are completely deleted, it spurs an error. At the end of of several dozen, perhaps a hundred rapid-fire close/open cycles, I also saw a couple of instances of an error that "File already exists"... seems like Excel was trying to create a file somewhere, but found that it was already there.
    (XL2010 on Windows 7 Professional SP 1)

    H0mogenized pasteurized milk from confinement animals, and butter, cheeses, and yogurts made from such milk, may look the same and carry the same name, but the inference that they are the same as [raw unpasteurized milk from pasture-fed cows] is part of the insidious deception that has been perpetrated on (us) the consumers of industrialized food.

    -Ron Schmid, "The Untold Story of Milk"

  8. #48
    New Member
    Join Date
    Apr 2012
    Posts
    1

    Default Re: Excel found unreadable content in "".

    Not sure if folks are still having issues with this, or if the "error" message covers a blanket of other issues, but I also recently had the issue of Excel suddenly telling me there was "unreadable content" in my workbook which was causing errors in other VBA automation I had written.

    The issue seemed to lie with the Table I had on one of the worksheets.
    To resolve the issue, I simply converted the Table to a normal range and then back to a Table again.

    I am thinking the root cause had to due with the data I was pushing (via TransferSpreadsheet) from Access.

    I hope this helps!

  9. #49
    Board Regular
    Join Date
    Dec 2007
    Location
    Houston
    Posts
    410

    Default Re: Excel found unreadable content in "".

    This issue seems familiar to my cut and paste protocol from Assess to Excel. Data transfer from Access to Excel was imperfect, in that the conversion of a column of text was pasted as Numbers. The first data cell defines the column in the paste. I would change put an alpha character in the first data cell and then paste into Excel.

    Most probably though, if boxes and triangles appear anywhere in the data:
    Decimal, hexadecimal, binary confusion/conversions
    Headers might be present (Hit,f2> key and also look in formula bar after doing)



    Quote Originally Posted by SumOtherGuy View Post
    Not sure if folks are still having issues with this, or if the "error" message covers a blanket of other issues, but I also recently had the issue of Excel suddenly telling me there was "unreadable content" in my workbook which was causing errors in other VBA automation I had written.

    The issue seemed to lie with the Table I had on one of the worksheets.
    To resolve the issue, I simply converted the Table to a normal range and then back to a Table again.

    I am thinking the root cause had to due with the data I was pushing (via TransferSpreadsheet) from Access.

    I hope this helps!
    Dan Rittgers MBA - CSM (expired)

  10. #50
    Board Regular
    Join Date
    Sep 2012
    Posts
    52

    Default Re: Excel found unreadable content in "".

    Was there ever a Universal root cause/solution found on this? Basically, my result of this error removes four macro enabled buttons from two seperate tabs (error indicating futher that XML drawing 2 and 3 have been removed to ensure the successful repair of the file).

    Regards,

    Hollando

Page 5 of 6 FirstFirst ... 3456 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com