• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 583
  • Last Modified:

Pivot Table excel 2007 to covert in excel 2003 format

Hi,
I have a 32 sheets work book that fetches data from different sources after data cleansing and filteration of data i have created a pivot table  which get refreshed once all the data related procedure gets over
My requirement is now to export the sheets containg this pivot table and its underlying data (So in all two sheets only )sheet in previous version i.e excel 2003. so that majority of viewers can see this file.As I try this  by saving in compatiable mode i.e. ".xls" . Pivot table structure get lost only the values left.
I read somewhere to change pivot table version (earlier) and than save it in order to remain pivot intact but don't know how to do this please help.

Also after data cleansing steps raw data for pivot is well under lmit,  i.e.  number of rows are much less than excel 2003 row limit.

0
Rajnish_Sharma_ibm
Asked:
Rajnish_Sharma_ibm
  • 4
  • 3
1 Solution
 
Rory ArchibaldCommented:
A pivot table created in the later format cannot be converted - you have to recreate it in a workbook that is already saved as an .xls file.
0
 
Rajnish_Sharma_ibmPrinciple ConsultantAuthor Commented:
can i  recreate this pivot table  in excel 2003 .i.e. .xls format from  my vba 2007 code
0
 
Rory ArchibaldCommented:
Is the pivot table created in code? If so, you can specify that it is created in the older format when you run the code.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Rajnish_Sharma_ibmPrinciple ConsultantAuthor Commented:
If you can give me a small snippet of code for this (i.e. code specfying pivot table format ) that will help me a lot!
0
 
Rory ArchibaldCommented:
If you are using the CreatePivotTable method, then the third argument is the default version, so you should specify xlPivotTableVersion10.
0
 
Rajnish_Sharma_ibmPrinciple ConsultantAuthor Commented:
Kindly provide all points to rorya as the solution is ok and close the question
0
 
Rajnish_Sharma_ibmPrinciple ConsultantAuthor Commented:
close question and provide comments to rorya
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now