Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Pivot Table excel 2007 to covert in excel 2003 format

Posted on 2010-11-23
8
Medium Priority
?
581 Views
Last Modified: 2012-05-10
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
Comment
Question by:Rajnish_Sharma_ibm
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 34196266
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
 

Author Comment

by:Rajnish_Sharma_ibm
ID: 34196411
can i  recreate this pivot table  in excel 2003 .i.e. .xls format from  my vba 2007 code
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 34196425
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
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 

Author Comment

by:Rajnish_Sharma_ibm
ID: 34196450
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
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 2000 total points
ID: 34196569
If you are using the CreatePivotTable method, then the third argument is the default version, so you should specify xlPivotTableVersion10.
0
 

Author Comment

by:Rajnish_Sharma_ibm
ID: 34428548
Kindly provide all points to rorya as the solution is ok and close the question
0
 

Author Comment

by:Rajnish_Sharma_ibm
ID: 34428555
close question and provide comments to rorya
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question