Share via

What does this mean: Repaired Records: Format from /xl/styles.xml part

Anonymous
2016-07-13T18:10:21+00:00

Hello all,

From what I understand the following indicates that Excel ignored some of the formatting for the data downloaded from my Access db, but did not delete any data.

Is this correct?

Thanks,

Al

<?xml version="1.0" encoding="UTF-8" standalone="true"?>

-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error162720_01.xml</logFileName>

<summary>Errors were detected in file '\Hhsisi001\aduser$\ahmet.toprak\My Documents\Table_Encounters_20160713.xlsx'</summary>

-<repairedRecords summary="Following is a list of repairs:">

<repairedRecord>Repaired Records: Format from /xl/styles.xml part (Styles)</repairedRecord>

</repairedRecords>

</recoveryLog>

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-07-13T20:31:07+00:00

    Hi Al,

    Yes, this error indicates some format in the workbook make the content unreadable, and Excel has tried to repair the format. After this process, the custom style in the workbook may lose. However, the data in the it should not be affected. If you need further help on this issue, could you provide more detailed steps you have done before seeing this issue?

    Thanks,

    Eric Yang

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2016-07-13T23:28:42+00:00

    Hello Eric:

    I did not do any special. Here are my steps:

    1. I right clicked on the table icon
    2. Chose Export to Excel
    3. Chose Export data with formatting and layout
    4. Chose Open the destination file after the export operation is complete
    5. Pressed OK
    6. Cover message to the effect that there is a problem with the spreadsheet and asked me if it is OK to fix it.
    7. I indicated that it is OK to fix it.
    8. After a few seconds Excel  launched the spreadsheet
    9. I got the message I quoted in my first post

    Al

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments
  3. Anonymous
    2016-07-15T07:22:32+00:00

    Hi AI,

    Just like Eric said above, the data in Excel should not be affected after the Rrepair. However, the style and the underlying expressions may be lost.

    Regards,

    Linda

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  4. Anonymous
    2016-07-14T17:25:38+00:00

    Hello Linda,

    Thanks for your suggestions.

    I am not really too worried about the format I get on Excel. I choose "Export data with formatting and layout" option because it gets me to access the subsequent option "Open the destination file after the export operation is complete".

    I just wanted to make sure that I am not loosing any data.

    Al

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  5. Anonymous
    2016-07-14T09:59:39+00:00

    Hi AI,

    If only a few columns appear to be formatted differently or missing from the version in the source object, as a workaround, we suggest applying the formatting that you want manually in Excel.

    1.  Open the destination Excel workbook.

    2.  Right-click a column or a selected range of cells, and then click Format Cells.

    3.  On the Number tab, under Categories, select a format, such as Text, Number, Date, or Time.

    4.  Click OK.

    Otherwise, fix the source object in the Access database, and then repeat the export operation.

    Also, here is a link about troubleshooting common errors when exporting data to Excel from an Access database.

    Regards,

    Linda

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments