I have a excel file which was created in excel 2000 and is using getpivotdata
function. The function returns #REF when the file is opened in excel 2002 or
excel 2003. Is that anyway that I can convert function Getpivotdata from
excel 2000 to excel 2002 so that the file can be opened in excel 2002?