You are here:

Excel/Excel 2007 version - backup workbook

Advertisement


Question
Hello Philip,  I am fairly new to Excel.  I have information that I want to backup to make sure it does not get lost in case my computer dies or something happens.  My problem is, I have been checking everywhere on the internet and I cannot come up with an answer on how to back up my info.  Some even say, you cannot back it up.  Please check out the website I have listed below.  No help at all.  Thank you for any information you cna give me.

Wynneth

http://www.mvps.org/dmcritchie/excel/backup.htm

Answer
Wynneth,

How to make a backup file.

1. Open the file you want to have a backup of.
2. Select "File"
3. Select "Save As"

This will bring up the "Save As" popup menu.

4. In the upper right hand corner of the popup menu select "Tools"
5. Select "General Options..." from the drop down menu

This will bring up a "Save Options" popup menu.

6. Select the checkbox for "Always create backup"
7. Save
8. Save

This will make a backup file when you save your file.
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

All Answers

Answers by Expert:


Ask Experts

Volunteer


Philip Buckley

Expertise

In Excel 2003 I can handle all basic questions such as how to copy and paste, all medium type questions such as pivot tables, and also am proficient in basic macros. I am also quickly learning 2007 where everything is pretty much the same but all in different places. Please be as detailed in writing your question as possible as that goes a long way in my ability to give the best answer possible.

Experience

I have 20 years of business experience, mostly in the area of finance and business consulting. Currently I am a Senior Business Consultant with a small business consulting firm. As part of my daily activities, I regularly use Excel to help make small businesses more efficient.

Education/Credentials
MBA from the Crummer Graduate School of Business at Rollins College.

©2009 About.com, a part of The New York Times Company. All rights reserved.