LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MK
 
Posts: n/a
Default Converting Getpivotdata function in Excel '03 to Excel '00??

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Excel option to store trendline's coefficients in cells for use Miguel Saldana Charts and Charting in Excel 9 June 20th 05 08:45 PM
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) Alain79 Excel Discussion (Misc queries) 4 June 14th 05 07:34 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM


All times are GMT +1. The time now is 05:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"