Excel Getpivotdata Sum
May 18th 06, 04:03 AMposted to microsoft.public.excel.worksheet.functions |
Converting Getpivotdata function in Excel '03 to Excel '00?? The GetPivotData function arguments are different in Excel 2000, and I don't know of any way to automatically convert them from the Excel 2003 structure. In Excel 2000, the formula isn't automatically created when you link to a pivot table cell, so you'll probably have to rebuild them. MK wrote: I have a tough problem I really need solving. For work I had to do a huge report with a lot of getpivotdata function from a number of pivot tables. The platform i used was Excel 2003, which I use at home. However, I realised that at work they only have excel 2000, and it is the only version that employees are allow to use. When I opened up the file at work on Excel 2000, and although the numbers are there, when the pivot data changes or gets refreshed, the data on the reports with the Getpivotdata functions become errored. I heard that the syntax for the function in Excel 2003 is different from Excel 2000. I have been crying over this, and I am looking for a solution. please help, I am very desparate, as the report took me over 3 weeks to complete. Thank you in advance MK -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Excel Getpivotdata Ref Error
If you're using Excel for Mac 2011 and earlier, the PivotTable button is on the Data tab in the Analysis group. Excel will display the Create PivotTable dialog with your range or table name selected. In this case, we're using a table called 'tblHouseholdExpenses'. Turning off the GETPIVOTDATA function! Go to Excel Options, use the following shortcuts ALT F I for excel 2007; ALT F T for excel 2010 and above; In the formulas tab un-check the GETPIVOTDATA function. Now enjoy uninterrupted cell references. After you turn the GETPIVOTDATA thingy off, the cell references again flow as smooth as butter!