Pivot tables downgrade 2007->2003

MS EXCEL

    Sponsored Links

    Next

  • 1. Printing a dynamic print area
    I have a worksheet that uses external data, refreshed each time I open. The print area has to be reset each time so that the empty rows with formulas in the cells aren't printed. Not knowing the amount of data that will be inserted, I copied the formulas up to row 200. This gives me plenty of room for the external data, but I don't want all of the empty rows in my printout. Any ideas? Alex D Coker Home:901.861.2818 Fax:901.861.2459 Mobile:901.870.5615
  • 2. Division 2 numbers
    Hello I want generate at random numbers in 2 columns that results division was be only integer example: 6/2=3 or 4/2=2 or 9/3=3 i will be do that in visual basic thx for help gregor
  • 3. No alert when file already open
    Since migrating to XP we are getting random results on whether the alert appears indicating that another user has the file open. Mostly in Excel but occasionally in Word. They do get a message when they try to save indicating they have the file open read-only. Happening on W98 workstations too when the XP machines have accessed the files.

Pivot tables downgrade 2007->2003

Postby Przemek » Sat, 28 Nov 2009 17:56:54 GMT

Welcome.

I've created a few pivot tables in my report in Ex2007.
The problem is that there is a group of ppl who have Ex2003 and these pivot 
tables looses their functionality (expanding) when opened in this version of 
Excel. Of course files are saved as *.xls format but it doesn't change 
anything.

The one way to solve this problem is to create once again these pvt tables 
in Ex2003 using source table,
but i think its just time wasting process. Besides there are pvt tables 
without source, so i would have to generate them again.

I'll appreciate any hint helping me to get round this problem. 



Re: Pivot tables downgrade 2007->2003

Postby geoff_ness » Sun, 29 Nov 2009 19:50:59 GMT



This issue is a real PITA - I had a bit of a rant about it recently at
 http://www.**--****.com/ 
Basically the only way to get around it is to save the file in the
97/2003 format, then close it and re-open it before creating the pivot
table. Opening a file in the earlier format puts Excel 2007 in
Compatibility mode, which means that the pivot table created will be
version 10, i.e. your Excel 2003 users will have full functionality
when opening the file.

Re: Pivot tables downgrade 2007->2003

Postby Przemek » Tue, 01 Dec 2009 15:45:40 GMT


This issue is a real PITA - I had a bit of a rant about it recently at
 http://www.**--****.com/ 
Basically the only way to get around it is to save the file in the
97/2003 format, then close it and re-open it before creating the pivot
table. Opening a file in the earlier format puts Excel 2007 in
Compatibility mode, which means that the pivot table created will be
version 10, i.e. your Excel 2003 users will have full functionality
when opening the file. 



Re: Pivot tables downgrade 2007->2003

Postby Przemek » Tue, 01 Dec 2009 15:57:40 GMT

Thank U .

In the meantime, i was looking on the net for some solutions and didn't find 
anything.

I decided to change the code a little and replaced the value of parameter 
"version" in the ".PivotCaches.Create" syntax.
It solved the problem but forced me to generate reports once again. pity ;)





Similar Threads:

1.2003->2007 xlsm->2003 loses worksheet commandbutton functionality

I have a workbook that was (I think) originally created in 2003. I inherited 
it as a workbook that had three worksheets, no macros, no activeX controls, 
etc. To clean up data entry, I added a commandbutton (from the 'control 
toolbox' toolbar) that opens a userform, and hid the rest of the sheets. 
Since I use XL2003, I saved it as an XLS file.

I then sent it to my boss, who is on XL2007. He opened it, tested it, and 
approved it. Since 70% of our widely dispersed department uses XL2007, I 
asked him to save the file as an xlsm., then sent it back to me to post on a 
sharepoint site for our team. Before doing so, I tried to open the file to 
check something- and got the following error message:

"This file was created in a newer version of Microsoft Excel. The file has 
been converted to a format you can work with, but the following issues were 
encountered. The file has been opened in read-only mode to protect the 
original file.

- Uninitialized ActiveX controls will not be opened in this version of Excel"

When I acknowledge the error, then enable macros, I can see my main 
worksheet with the gray commandbutton, but clicking on it just selects it, as 
if I were in design mode. I can toggle in and out of design mode, but the 
button is dead.

(1) should I be using a different button to trigger my macro, i.e. is there 
one that can withstand the conversion to XL2007 and still work when 
downcoverted to XL2003?

Even if I upload a 2003 version, as soon as anyone with 2007 opens it, 
enters their data, and saves it, I'll be back to having a document that won't 
work for the next 2003 user.

Thank you,
Keith

2.office Standard 2007 downgrade office 2003

    office 2007 standard   downgrade  office 2003.
   ?

3.how can i downgrade office 2007 to office 2003

I need to downgrade from office 2007 to 2003. The PC's are DELL and came with 
2007 installed. Can I do this and how do I do it.

4.Downgrade MS Office 2007 - 2003 , licenses, productkey,...

I have to install MS Office Prof 2003 on two PC's of a costumer. Because i 
cant buy 2003 anymore, I want to buy 2 MS Offices Prof 2007 licenses and 
downgrade them to 2003 (not OEM - it is not allowed to downgrade i have read).
I got installation CD's of 2003. Can i use this product key for both 
computers or do i need to request new product keys? How can i do it and will 
there be additional costs?

Kind regards


5.Downgrading Office 2007 to 2003

Can't really find an answer to my question from searching old posts.
I want to downgrade from office 2007 standard to my old version of office 
2003.

I just want to confirm that if I export all my mail to a .pst file, 2003 can 
import it properly.  

Can office 2003 import a .pst made by office 2007?  Are there any other 
issues I should be aware of?  

Thanks

6. Downgrading from Office 2007 B2TR to Office 2003

7. Downgrade Office 2007 Academic edition to 2003

8. Downgrade from 2007 Beta to 2003



Return to MS EXCEL

 

Who is online

Users browsing this forum: No registered users and 21 guest