ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Getpivotdata - Excel 2000 vs. Excel 2002 and later (https://www.excelbanter.com/excel-worksheet-functions/41656-getpivotdata-excel-2000-vs-excel-2002-later.html)

giffordm

Getpivotdata - Excel 2000 vs. Excel 2002 and later
 
I received a file from a client that uses the getpivotdata function in the
2002 or later version of excel. my company uses excel 2000. is there any
easy way to convert the new version into the older format or vice versa?
it's a bit of a nightmare to go through and change all of their formulae
manually to use the older argument layout.
thanks.


All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com