What would you like to do?
2 people found this useful
Was this answer useful?
Thanks for the feedback!
There are some downloadable tools on the web which recreate the old or 'classic' Excel toolbar in Excel 2007. One such example you might want to take a look at can be found at… http://www.download.com/Classic-Menu-for-Excel-2007/3000-2077_4-10637173.html Regards, Jake Courtesy of www.Excel-Expert.co.uk
There are many differences between Excel 2003 and Excel 2007. Some of the changes in Excel 2007 are improvements. Some are strongly disliked by users of past releases of Excel…. The following are some of our major findings when we compared Excel 2003 to Excel 2007. We do recommend that if you have Excel 2003, that you do a custom install of Excel 2007 and tell it to keep all prior versions. This will allow you to use your prior version if you need it. The default installation of Excel 2007 automatically removes all prior versions. We think having the prior versions around is a good thing. Why should you upgrade to 2007? There are a number of good reasons:Number of rows increased from 65,536 to 1,048,576.Number of columns increased from 256 to 16,384.You do a lot of graphics work and need the new graphics tools and options (although some complain about the built in defaults and data)You do a lot of pivot table work and need the new pivot table features in 2007You are receiving workbooks that are Excel 2007 workbooksMaximum number of function arguments increases from 30 to 255Formula length increases from 1000 to 8000 charactersNesting levels for formulae increased from 7 to 64Unlimited cell-conditioning formats64 sort levels Office XML Formats allow for better data integration between documents and back-end systems. Also, with Excel XML Formats, you can reduce file sizes, improve data recovery, and increase the interoperability of your spreadsheets with other data sources such as line-of-business systems.Business dashboards can be easily created from spreadsheets to track key performance indicator.You can import external data into a spreadsheet by using pre-configured external sources of business informationDevelopers can use the Office Excel 2007 calculation engine in other applications, such as a Web-based mortgage calculator or an options pricing model. Why should you stay with Excel 2003 (or an earlier version)The Excel 2007 interface is harder to use. More functions are visible on the new menu system but the lists of functions are longer so regular functions are more difficult to find.You are used to using Excel 2003. You will find that using Excel 2007 takes longer to do many of the tasks you used to do. This is part experience and part design. The first can be overcome, but it will take time. If you have used Excel 2003 for years. New file formats and file name suffixesFiles are largerNo Lotus123 support or conversion to versions before Excel v4 Pre-Excel 2007 versions need additional drivers to read Excel 2007 filesNo change to any statistical functions between Excel 2003 and Excel 2007 Macro recording of chart macros works very poorly in Excel 2007. What options do you have to overcome the above three problems?A number of companies sell products that add back the classic Excel menus to Excel 2007. In all cases, you do not get all the menu items as some have disappeared. And new features are not found on the new menus.If you do chart macros, you can always use Excel 2003 to record a macro and then copy it to Excel 2007. Some modifications may be necessary however to get the code to work correctly.If you are very statistically minded, see the review of Excel 2007 in "Computational Statistics and Data Analysis 52 (2008) 4568-4606" (www.elsevier.com/locate/csda), "On the accuracy of statistical procedures in Microsoft Excel 2007", McCullough and Heiser.
"Overall interface is the only difference." This statement wildly inaccurate and misleading! There are many substantial differences between Excel 2007 and Excel 2003. Your o…rganization may incur major costs in converting to Excel 2007, especially if you have a large number of spreadsheets that are linked or make references to one another. The user interface is entirely new. You will likely find it takes you longer to do your work. The "learning curve" is substantial. It is very much like learning a new product. On the other hand, you may find some of the new features valuable after you have learned Excel 2007. Some features, such as pivot tables, have incompatibilities between the two versions. For example, Microsoft states: "PivotTables in Office Excel 2007 cannot be made interactive in earlier versions of Excel, and Office Excel 2007 does not downgrade the PivotTable version when earlier-version file formats are saved." If you publish excel tables to the web with the "Save As HTML to publish HTML", know that Excel 2007 makes major changes to this feature. You may have to change the way you work with this feature. Other features have been removed and are no longer available in Excel 2007. The official Microsoft answer to your question is located at a link below: Note that this site provides a marketing answer. As such it is incomplete since it does not present "negative" information or show adverse impacts, such as major costs associated with adopting Excel 2007, may have on your organization. Another answer is located here Add-ins.com and is also given below. Note that this site, too, provides a "biased" answer since the site is from a company that sells "add-on" products for Excel 2007. But this site offers a great advantage to you: it has a table which lists specific features of Excel and shows the differences between the two versions and the impact of adopting Excel 2007. This site states that it includes information derived from user postings on news groups.
In Excel 2003 you would normally position your cursor in the cell to the right of vertical titles and below verical titles. The choose WIndow Freeze Panes. In 2007 …choose the View tab and there is a button for Freeze panes on the Window group For Differnces between the versions try http://www.mousetraining.co.uk/ms-office-training-manuals.html. For a interative guide where you select old menu in 2003 it shows you new position in the new version 2007 http://office.microsoft.com/en-us/powerpoint/HA101490761033.aspx?pid=CH100668131033
There is no direct option available to convert MS Excel 2007 look and feel changed to MS excel 2003. However, you can customized the MS Excel 2007 to your need. Cli…ck on MS Office icon on top right hand side corner. Click on MS ExcelOptions. Click on Customize and add the icon/command as per your needs. Regards, Sarfaraz Ahmed
The main difference is the whole look, in terms of having ribbons instead of menus. A lot of the same icons are there, but it may at first take a bit of getting used to where …they are. In terms of things like specific kinds of formulas and functions and things that can be done with a spreadsheet, then it doesn't make much difference in which version you use, even ones earlier than 2003. Spreadsheets are designed to do certain kinds of tasks, and any spreadsheet can do them. So it really is the look of 2007 that is most different. Experienced users of 2003 will quickly adapt to 2007 when they get used to where things are on the ribbons. so it will depend on your level of experience.
Sure. Just click on the graph, then click and drag on one of the edge handles (either a small box in each corner, or a double-headed arrow when you hover over one of the graph… border lines). Repeat, as needed, to position the graph where you like.
The most obvious visible difference is the ribbon bar (new menu system) displayed by all Office 2007 products. You also will notice a new file format. Excel 2003 uses an exten…sion of XLS, while Excel 2007 uses the extension of XLXS, You can open Excel 2003 files in Excel 2007, but not the other way around. Excel 2007 adds many new functions. See related links for what's new with Excel 2007. Also see the related links for how to match the old Excel 2003 menu items with the new Excel 2007 ribbon.
dont think you can
Excel 2003 = .xls Excel 2007 = .xlsx
Open the file with Excel 2007 and save as an Excel 2007 file. Other than that, you might be able to find a file converter program to do it for you, but I am not sure why.
For a standard spreadsheet, both versions can do what you want.2003 looks very different and some people found 2007 difficult toadapt to, but once they got used to it, they fo…und the fundamentalswere not very different. So it is really personal choice. Peoplewho are used to 2003, might stick with it while people completelynew to Excel would go for 2007.
Yes vba written in excel 2003 is usually compatible with excel 2007 but you can never be 100% sure without testing on both platforms. There are however backwards compatability… issues namely around activex controls which do not work too well in 2003 but this can be overcome by saving the file in 2003 format
The most dramatic difference is in the interface, changing from a menu driven system to using ribbons. So Excel 2007 looks very different and takes some getting used to. Most …of the functionality is still there, and you will still find the icons and the shortcut keys will still work.
Do a Save As, and pick the 2003 version. It can then be opened by any of the 3 versions. Depending on what is in the original document, it is possible that you could lose some… things. Most Excel spreadsheets will not lose anything when they are saved into an earlier version.
Default file format for Excel 2003: .xls Default file format for Excel 2007: .xlsx Note: You can't open lower version file format in upper version. If you want to do this the…n you will have to download the compatibility pack.