Error when exporting to Excel

  • Anyone please help me w/ my prob w/ exporting my report to excel. I am encountering such error message when exporting my report to excel:

    "Errors were detected in file 'C:\Documents and Settings\Administrator\Local Settings\Temporary Internet Files\Content.IE5\MRS7UDG7\MyStore™ Performance (Estate).xls'

    The following is a list of repairs:

    Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted."

     

    I am just wondering, why there are just some instances i am encountering this error / data corruption, but sometimes, my report when exported to excel is just fine.

    Please, anyone help me w/ this prob. Could this a cause by large report size, since my report contains drilldowns and graphs? Or is this a known bug or RS? Anyone please, explain why this happens.

    Thank you so dearly.

     

    Regards,

    Althea Umali, software developer

     

  • There are problems rendering to Excel, depending on the version of Excel you are using.

    Have you installed the Reporting Services service pack?

    If not its here:

    http://www.microsoft.com/downloads/details.aspx?FamilyId=580FEBF7-2972-40E7-BCCF-6CD90AC2F464&displaylang=en

  • yeah..Im using SP2.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply