+ Reply to Thread
Results 1 to 2 of 2

Problem with pivot tables connected to SSAS 2008 R2 in Excel 2010: "Excel found unreadable

  1. #1
    Registered User
    Join Date
    07-22-2014
    Location
    Moscow, Russia
    MS-Off Ver
    Excel 2010 14.0.7128.5000 (32 bit) SP2 MSO
    Posts
    1

    Unhappy Problem with pivot tables connected to SSAS 2008 R2 in Excel 2010: "Excel found unreadable

    Hi,

    I have such problem when I open in Excel 2010 14.0.7128.5000 (32 bit) a xlsx-file containing pivot tables and slicers connected to SSAS 2008 R2 cube:
    - Excel found unreadable content in '...'. Do you want to recover the contents of this workbook? If you trust...
    https://yadi.sk/d/uqXoH73jUyboq

    And this text after clicking "Yes":
    Removed Feature: PivotTable report from /xl/pivotCache/pivotCacheDefinition2.xml part (PivotTable cache)
    Removed Feature: PivotTable report from /xl/pivotCache/pivotCacheDefinition3.xml part (PivotTable cache)
    Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)
    Removed Feature: PivotTable report from /xl/pivotTables/pivotTable3.xml part (PivotTable view)
    Removed Records: Workbook properties from /xl/workbook.xml part (Workbook)

    What may be the reason?

    It has become a regular at some point for files created in Excel 2013. But this file was created in the same excel in which I try to open this file.

    Thanks for help in advance.

    Best regards,
    Nikolay

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Problem with pivot tables connected to SSAS 2008 R2 in Excel 2010: "Excel found unread

    Hi,

    Did you try clearing the Pivot Table Cache?

    1. Right Click on the Pivot Table
    2. Pivot Table Options
    3. Goto Data Tab
    4. Number of Items to retain per field -> "None"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Getting: "Excel found unreadable content in 'MyWorkbook.xlsm'..."
    By Ragnaros in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-22-2013, 09:06 PM
  2. Error "Excel found unreadable content" due to autofilter
    By JChandler22 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-05-2012, 02:38 AM
  3. Excel found unreadable content problem!!!
    By waryfaraj in forum Excel General
    Replies: 0
    Last Post: 09-18-2012, 01:13 PM
  4. Replies: 0
    Last Post: 08-17-2012, 07:00 AM
  5. [SOLVED] Pivot tables connected to SSAS issues
    By Mike L in forum Excel General
    Replies: 1
    Last Post: 06-19-2006, 03:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1