ms excel pivot file in calc???

rocafella · Newbie Joined: 20 May 2006 Posts: 2

dear all,

i am opening a excel pivot table file in calc and wondering how it works??

in excel when you open the file with the pivot table and double click on an amount (example)
it opens a new workbook with a summary/ detailed list of the amount i double clicked on.
now the excel file in calc does not open or give me any option to double click or anything. is there something i have to change in the options? or is it not possible to open excel created pivot tables in calc?

many thanks in advance
peter

carl · Posted: Mon Jun 05, 2006 10:54 pm Post subject:

I dont have MS but I can tell you that in Calc DataPilot helps you analyse a sheet
_________________
carl
Using OpenOffice.org 2 on XP sp2