Content problem in microsoft office 365

Sameena Tara 1 Reputation point
2021-02-23T12:05:37.887+00:00

Hello Team,

When i am trying to open an excel file using Microsoft office 365 excel (vesion showing as 2008) , I am getting a popup message as "we found a problem with some content ....xls. do you want us to try to recover as much as we can? if you trust the source of this workbook click yes."
And, after clicking "yes", i am getting another popup as (Repairs were made to pivottable report pivot 1 on....xls)

Attached are the screenshots.

could you please help?

Thanks, Sameena

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,674 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Emily Hua-MSFT 27,571 Reputation points
    2021-02-24T07:58:20.32+00:00

    @Sameena Tara
    Do you know which version of Excel created this .xls file?
    Could other people open this file correctly?
    If the pivot table was created in an older version of Excel but you want to open it through Excel for Microsoft 365 apps, this behavior may causes such error message.
    Besides, if there is somthing wrong in Pivot Table, you would also see such error message.

    It's recommended to back up this file first.
    Go to Excel app > File > Formulas > Caculation Options, set "Manual" for Workbook calculation. Then open this file from Excel app to check this issue.

    Change the format, such as .xlsx, re-open this file, create a new pivot tabe via Excel for Microsoft 365 apps.

    Besides, you may refer to the article "Repair a corrupted workbook" to have a try.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Sameena Tara 1 Reputation point
    2021-02-25T08:20:20.663+00:00

    And also, I have checked the calculation mode is set to manual only.
    The workbook is saving automatically in Excel 97-2003 workbook format in 2010 version.

    What should I do now? Pls help me.

    Thanks,
    Sameena


  3. Sameena Tara 1 Reputation point
    2021-03-01T05:44:33.637+00:00

    Hello Team,

    Any suggestions pls? I am still getting that content error and pivot table error in Microsoft office 365 excel version 2008 . but, I can able to open in excel 2010 without any issues.

    Appreciate your response!

    Thanks
    Sameena