Skip to Content
author's profile photo Former Member
Former Member

Corrupt BEx workbooks - How to recover

Hi experts

I read this blog:

Under item 4 the ENTIRE content of this temp-folder should be deleted.

My question: If you only have one corrupt workbook, the rest work fine, wouldn't the deletion of the whole content of this folder that all workbooks get deleted?

How does the mechanism look like?

Where are the workbooks physically stored?


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 09, 2014 at 09:52 AM

    Dear Thomas,

    Thanks for referring to my document..
    generally when you execute the workbook on your system, it is stored in the temp folder in your system. Physically the metadata of the workbook is stored in BW system in tables like


    List of binary large objects (Excel workbooks)


    Titles of binary objects (Excel workbooks)


    Storage for binary large objects (Excel workbooks)


    Assignment of Excel workbooks as personal templates


    Where-used list for reports in workbooks

    Generally we recommend to delete the contents of temp folders very frequently.
    It does not affect the execution of the workbook if the contents of the folder are deleted.


    Add a comment
    10|10000 characters needed characters exceeded

    • Dear Thomas,
      I am sorry.. I misunderstood your question. Apologies..

      Open the workbook in a new Excel session without BEx Add-in MEANS.. when you double click the excel from the temp folder.. make sure that BEx analyzer should not be started .. we donot need BEX Analyzer here.. we need to work with only excel. In other words.. you should not see the Add-in Menu Option in Excel.
      You can achieve this by first closing BEx Analyzer session opened if anyand then start workbook from temp folder..

      Please let me know if I could make my self clear..


  • Posted on Dec 08, 2014 at 04:34 PM

    Hi Thomas,

    the workbooks are stored on the BW server.

    So if you folloe the blog, in step 4 you only delete local copies on your PC.

    All workbooks including the corrupted one will still be untouched on the BW server.

    Only in the last step, where the blog requests you to save the local workbook back to the server, any workbook in BW will be overwritten.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.