Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
GETPIVOTDATA between XL 2K & 03
I have a client with Office 2000. He shares files with users that have Excel
2003. Is there a way that the GETPIVOTDATA function can be used successfully in both versions? -- maryj |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
GETPIVOTDATA between XL 2K & 03
The function's arguments are different in Excel 2003 and Excel 2000.
If you create the formulas in Excel 2003, and users open the files in Excel 2000, the formulas will return an error if the pivot table is refreshed or changed, or if they recalculate the formula. If you create the formulas in Excel 2000, Excel 2003 should calculate them correctly if the pivot table is refreshed. Layout changes may cause errors. maryj wrote: I have a client with Office 2000. He shares files with users that have Excel 2003. Is there a way that the GETPIVOTDATA function can be used successfully in both versions? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
GETPIVOTDATA between XL 2K & 03
Thank you Debra.
Next question - The Getpivotdata function in the Excel 2003 file is =GETPIVOTDATA("Circuits Scrapped",$A$3,"Year",2006,"Month",2). All of the examples I have seen using the this function in Excel 2000 only have arguments for pivot table and one argument for a field name. Is it possible in Excel 2000 to have the function look for more than 1 pivot table field? -- maryj "Debra Dalgleish" wrote: The function's arguments are different in Excel 2003 and Excel 2000. If you create the formulas in Excel 2003, and users open the files in Excel 2000, the formulas will return an error if the pivot table is refreshed or changed, or if they recalculate the formula. If you create the formulas in Excel 2000, Excel 2003 should calculate them correctly if the pivot table is refreshed. Layout changes may cause errors. maryj wrote: I have a client with Office 2000. He shares files with users that have Excel 2003. Is there a way that the GETPIVOTDATA function can be used successfully in both versions? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
GETPIVOTDATA between XL 2K & 03
In Excel 2000, it would be similar to this:
=GETPIVOTDATA($A$3,"'Circuits Scrapped' Year 2006 Month 2") maryj wrote: Thank you Debra. Next question - The Getpivotdata function in the Excel 2003 file is =GETPIVOTDATA("Circuits Scrapped",$A$3,"Year",2006,"Month",2). All of the examples I have seen using the this function in Excel 2000 only have arguments for pivot table and one argument for a field name. Is it possible in Excel 2000 to have the function look for more than 1 pivot table field? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
GETPIVOTDATA between XL 2K & 03
Thank you Debra!
-- maryj "Debra Dalgleish" wrote: In Excel 2000, it would be similar to this: =GETPIVOTDATA($A$3,"'Circuits Scrapped' Year 2006 Month 2") maryj wrote: Thank you Debra. Next question - The Getpivotdata function in the Excel 2003 file is =GETPIVOTDATA("Circuits Scrapped",$A$3,"Year",2006,"Month",2). All of the examples I have seen using the this function in Excel 2000 only have arguments for pivot table and one argument for a field name. Is it possible in Excel 2000 to have the function look for more than 1 pivot table field? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GETPIVOTDATA help | Excel Discussion (Misc queries) | |||
getpivotdata | Excel Discussion (Misc queries) | |||
GetPivotData need help | Excel Worksheet Functions | |||
getpivotdata | Excel Worksheet Functions | |||
GETPIVOTDATA | Excel Worksheet Functions |