• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unreadable content error (pivot table related)

A

Andrei

New Member
Hello to all,

I have a problem with one workbook i made and i am trying for one week to solve it but nothing worked.. I have errors when i open the workbook: "Excel has found unreadable content.." and after that, if i click"yes": "Removed Records: Object from /xl/pivotTables/pivotTable2.xml part (PivotTable view)". I tried also to make once again the workbook (i copied the user forms and macros into Word and then i created a new workbook and made all the file again) but when i reached to the sheets with Pivot Table ("Raport" and "Raport_VAL") and generated the reports i got the same errors.. I used only Excel 2010, but i worked on 2 computers..

Do you have any ideea what is the cause of this error and how can i get rid of it ?

The file was too big to attach, but i put one link for download after this phrase.. Sorry, it's in Romanian language but the ideea is that from one sheet there are generated 2 pivot tables in 2 other sheets using Macros.

http://speedy.sh/qMQU2/for-Chandoo-forum.xlsm

Thanks !
 
Hi Andrei ,

I use Excel 2007. However , when I downloaded your file , and ran the macros in the two tabs Raport and Raport_VAL , there were no problems ; of course I had to change references to the version from :

xlPivotTableVersion14

to

xlPivotTableVersion12

Additionally , I had to change the starting cell in the following segment of code , from B7 to B8 :

Range("B8").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ShowDetail = False

I have re-uploaded the file for you to check ; you will have to change the pivot table version back to its original value.

http://speedy.sh/vJ7ay/for-Chandoo-forum.xlsm

Narayan
 
Hi Narayan,

Thanks a lot for looking at the Workbook ! I downloaded the new file and in the first time it did not give the error, but after i played a little bit with the PT (refresh, delete, generate) i got it again after i Saved and reopened the file :( The macros run well but the problem is that i have to save the file with Save As all the time and i can't figure out what's the reason of these errors..

It might be related with the Excel that i have installed on my PC ? Would it help a reinstalation ?

Or should i install Excel 2013 ? (i don't know if it's better)
 
Hi Andrei ,

Check whether the problem is still present with this uploaded file , which has been passed through the Code Cleaner add-in.

I have tried running the reports several times , saved and re-opened the file several times without any problem. If you still have problems , you can try repairing your Excel installation once.

http://speedy.sh/TwZ3R/for-Chandoo-forum-cleaned.xlsm

Narayan
 
Hi Narayan,

Still the same problem, i supose the file it's not corrupted if it worked fine at you and the problem is releted with my Excel... How can the Excel installation be repaired ? (only reinstall ?)

Thanks
 
Hi Narayan,

I think i solved the problem: i deleted the 2 sheets, created new ones and recorded again the macros for Pivot Tables.. I played a little bit and it did't give the error untill now.

However, i tried to open the file also with Excel 2007 and it did't work at all: when i pressed the buttons (all of them) it said something like: object missing.

Thanks a lot !
 
Hi Andrei ,

Since the pivot table version is to be specified in the code , having the version as xlPivotTableVersion14 ( which refers to Excel 2010 ) will generate an error when you run it in Excel 2007 ; before running it in Excel 2007 , change all references to xlPivotTableVersion14 to xlPivotTableVersion12 ( which refers to Excel 2007 ).

Narayan
 
You must log in or register to reply here.
Back
Top