Welcome toExcel2007.Tips.Net
Helpful Links
Gardening Tips
Organizing Tips
Word2007 Tips
WordTips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Upgrading Personal.xls to Excel 2007
Summary: When upgrading to Excel 2007, you may wonder how you can convert your older Personal.xls file to something that can be used with the newer program. Here's the easiest way to make the transition.Billy's boss is getting a new PC, and he is responsible to get the system set up for her. Her old PC has Excel 2000, but the new system will have Excel 2007. He needs to get her old Personal.xls to the new PC, as it has all her macros in it. Billy wonders if he can just copy and paste Personal.xls from the old system to the new one.
The short answer is "probably not." Excel 2007 uses a new file format based on XML—in fact, Excel 2007 doesn't even use a file called Personal.xls, but Personal.xlsb. It is best to have your Personal.xls file in this new format. That doesn't mean that you can't get the old information to the new system, however. The way you do that is to follow these general steps:
- Copy the old Personal.xls file to the new system.
- Rename it something else, such as OldPersonal.xls.
- On the new system, start Excel and open the Excel 2007 Personal.xlsb file.
- Open the OldPersonal.xls file.
- Copy the macros from the old file to the new one.
- Save the new Personal.xlsb file.
That should be it—your macros will be on the new system.
Related Tips:
Document and Annotate! One of the easily overlooked tools provided by Word is the ability to add footnotes and endnotes to your documents. WordTips: Footnotes and Endnotes is the definitive resource guide to using these tools to enhance your documents. Check out WordTips: Footnotes and Endnotes today!