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.
It depends what version you are using. Excel 2013 only has one worksheet by default, but earlier versions had three. Note that you can change the number of sheets when creating a new workbook via Excel options.
In Microsoft Excel, a new workbook will normally have three worksheets.
You can use a hyperlink to link from a Word document to an Excel document. Select the text you want to act as the link and press Ctrl-K. You can then find the excel workbook you want to link to. You can also copy from an Excel document and paste as a hyperlink, using Paste As Hyperlink in the Word document. This can link to a specific point in the Excel Workbook. You can also do a Paste Link to maintain a connection between the two files, so that when there are changes in the Excel workbook, they will be seen in the Word document.
An Excel spreadsheet is called a workbook. Each individual page is called a worksheet.
Excel 2003: .xls = Workbook .xla = VBA Add-in .xlb = Toolbar (where custom toolbar settings are stored) .xlc = Chart .xld = Dialog (from older versions of Excel) .xlk = Archive (Excel spreadsheet backup) .xll = DLL Add-in .xlm = Macro .xlt = Template .xlv = VBA Module .xlw = Workspace (collection of multiple Workbooks) Excel 2007 and Excel 2010: .xlsx = Workbook (XML format) .xlsm = Macro-enabled Workbook .xlsb = Excel Binary Workbook (instead of XML format) .xltm = Macro-enabled Template .xlam = Add-in (XML format)
Depending on if you have them open in separate windows of Excel.If they are in the same window: * Ctrl + F4 = Closes the active workbook. If they're in separate windows: * Alt + Tab = Changes your active window * Ctrl +F4 = Closes the active workbook. OR * Alt + F4 = Closes Excel; closes the program. * Ctrl + W = Also closes the active workbook (It doesn't matter if you have extra sheets in Microsoft Excel, unless if someone tells you it does matter.)
It saves a workbook in the specified format to the specified folder. So normally it saves in the standard Excel format for the version you are using and saves the file in the My Documents folder, or whichever folder you select.
If you have 2010, then you can open it and save it as a 2010 workbook. It won't open with Excel 2003 after that though so you cannot have the benefit of the extra rows in Excel 2003. That is one of the reasons for using 2007 or 2010.
When an Excel file goes haywire, don't give up hope. Using one of these recovery tricks, you may still be able to salvage the data.Even if you faithfully back up your Excel workbooks, corruption can still be a problem. The backup files won't always contain your most recent work, so you'll probably end up re-entering data. Repairing a corrupted workbook, if possible, is a better option. In this respect, Excel can help. If you attempt to open a corrupted workbook, Excel will engage File Recovery mode, which attempts to repair the workbook. If that works, great! Unfortunately, Excel's automated File Recovery feature sometimes fails to repair a damaged workbook. When this happens, you'll need alternatives. Try the easiest solutions first. The more complex methods usually recover data, but no formulas, formatting, charts, or macros.Note: This article is also available as a PDF download.
By default Excel should save files in the .xml or .xmlx format (the latter being the default format for Excel 2007 & 2010). Other common formats that Excel accepts include .cvs and .txt. If you have that (or any other format) this is the easiest way to change the format:Open the file in Excel. Select "Save As" from the tile menu/office button (depending on your version of Excel). When you're prompted to select a location and file name, change the file type (using the drop down menu at the bottom of the screen) to Excel workbook (if you're using a version older than 2007) or Excel 97 - 2003 workbook (if you using 2007 or newer).There other methods, but they require slightly higher degrees of technical proficiency than this one.
It will save it with the name you specify and as the default type of workbook for the version of Excel you have. You should give the file a name, but if you don't it will call it Book1 and then add the appropriate extension. For the more modern versions, which is Excel 2007 onwards, that would be .xlsx, but if you are using an older version than Excel 2007, then it would be .xls instead.
Usually because its been protected by the creator!