answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How can you save and Excel 2010 workbook if some is still using Excell 2003 or 2007?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

When you open an Excel workbook how many sheets by default does a workbook have?

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.


How many worksheets does Excel have when it opens a new workbook?

In Microsoft Excel, a new workbook will normally have three worksheets.


How do I link an Excel spreadsheet item to a paragraph in a Word document?

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.


When Excel starts it creates a new empty called Book1 which is like a notebook?

An Excel spreadsheet is called a workbook. Each individual page is called a worksheet.


What is the file extension that indicates an Excel file?

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)


If two Microsoft Excel sheets are opened together then how can I close one of the windows of the Excel sheet with the keyboard i.e. without using the mouse?

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.)


What does Excel save it's information to?

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.


Can you convert an Excel 2003 spreadsheet to 2010 to add more rows?

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.


To reopen a workbook once Excel is opened you can check what from the office menu?

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.


How do you change Excel file into xml file?

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.


When you save a document in Excel what does it save as?

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.


Why can't you delete an Excel sheet?

Usually because its been protected by the creator!