Excel 2003 and 2007 on the same PC
Excel 2003 and 2007 on the same PC
(OP)
If anybody tried to install two versions of Excel on one PC? Is it possible? What is the order of installation?
Thanks!
Thanks!
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
Excel 2003 and 2007 on the same PC
|
RE: Excel 2003 and 2007 on the same PC
"Wildfires are dangerous, hard to control, and economically catastrophic."
Ben Loosli
RE: Excel 2003 and 2007 on the same PC
Is there that much difference that you need to have both?
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Excel 2003 and 2007 on the same PC
Had the same issue with 2007 and another CAD package, where the CAD would not work at all with Excel 2007 because of the default XML file names. IT director said just do a Save As. Took about 15 emails and a couple of hours to finally get it sunk into her head that solution would not work because the CAD software was looking for .xls formatted files.
"Wildfires are dangerous, hard to control, and economically catastrophic."
Ben Loosli
RE: Excel 2003 and 2007 on the same PC
Well many people seem to think that the new menu system is the work of the devil, although I don't mind it myself, but apart from that, if you want to use VBA with graphic objects (including charts) there are 2 good reasons for having an earlier version installed:
1. The 2007 macro recorder does not record anything you do to graphic objects, including charts.
2. Thare have been some significant changes to the object model for various shapes. Arcs for instance are defined differently in 2007 to earlier versions.
Even if you don't do any VBA programming with shapes and charts it is a good idea to check out any applications written in 2007 with an earlier version.
looslib - You know you can set the default save format in 2007 to .xls (97-2003 format)?
I have one computer with 2000 and 2007 and another with 2003 and 2007 and have no problems. On the same drive in both cases. I associate all Excel files with 2007, and if I want to run the earlier version I start it up without a file, then either double click on the file name, or use the Excel menu.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Excel 2003 and 2007 on the same PC
"Wildfires are dangerous, hard to control, and economically catastrophic."
Ben Loosli
RE: Excel 2003 and 2007 on the same PC
RE: Excel 2003 and 2007 on the same PC
There're some differences in VBA which prevent files to run properly on the new version.
<<
VBA hasn't changed (as far as I know), and I don't recall having any problems getting any of my old macros to run in 2007, other than the fairly esoteric change to arc shapes that I mentioned previously.
But I do agree it's a good idea to have an earlier version installed.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Excel 2003 and 2007 on the same PC
I encountered the following problem. The name of automation library for Solver has changed from solver.xla to solver.xlam. As a result Excel 2007 cannot find proper library and gives an error. The problem is easily fixed by changing the reference.
RE: Excel 2003 and 2007 on the same PC
John Southard, M.S., P.E.
http://www.pdhlibrary.com
RE: Excel 2003 and 2007 on the same PC
I also prefer the earlier versions with simpler customization of menus and toolbars.
RE: Excel 2003 and 2007 on the same PC
- the files are half size of 2003 (if you care)
- it runs properly on Windows 7 (2003 does not, the worksheets within the same workbook become kind of transparent)
- it checks for errors in the formulas and names
- charts are much better
- drawing tools more extensive
- the ribbon is Ok if you have time to learn it (we will have to anyway).
Yakov
RE: Excel 2003 and 2007 on the same PC
1. How do I change the VBA macro to make Solver work in Excel 2007?
2. Can I make the same xls file work for computers running Excel 2000, 2003 and 2007 as long as the appropriate Solver addin is loaded?
I need some simple directions to make this work! I am NOT a VBA wiz. Thanks all.
RE: Excel 2003 and 2007 on the same PC
I'm not sure if this can be automated. I don't think so, but I'll check.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Excel 2003 and 2007 on the same PC
h
Let us know how you go.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Excel 2003 and 2007 on the same PC
On the 2003 version, I had to untick MISSING:Solver.xla and manually run just the Solver, then I could go back and tick Solver. The VBA macro runs now, but the results are way out in the blue.
RE: Excel 2003 and 2007 on the same PC
RE: Excel 2003 and 2007 on the same PC
The solver on the machine with 2003 is working, but the results are crazy wild. We are using the same xls file with the same values.