Microsoft Excel - Save as - Asked By Phil on 04-Aug-11 07:13 PM

I'm using Excel 2010 on 2 laptops and a desktop. On one laptop when i want to save a file using 'save as" it doesn't come up as ask me for a file name and where on the network to save. Other CPUs work okay. I uninstalled and reinstalled the software. Please help'
Irfan Khan replied to Phil on 04-Aug-11 07:36 PM
There is a difference between Save and Save as

When you create a brand new document and click on the Save button on your Standard Toolbar, you will be presented with the Save As dialog box because Excel wants to know three things:

Where do you want to save it?

What do you want to name it?

What file type do you want it to be?

Once you have saved your new document, clicking on that same button no longer gives you these choices. Why? Because Excel assumes you do not want to make those three choices again. Excel assumes you simply want to update the originally saved copy by overwriting it with this new version of the same file. If, however, you do want to either put a copy of this same file in a new location, create a new copy with a new name, or change the file type, you must go to the File menu and choose Save As.

Remember that Windows will not allow you to have two files with the exact same name in the same folder, so when you save a file to a location where that file already exists, Windows will replace the existing file with your new one. So, if you do not want to overwrite the existing file, but rather want to create a copy with a different name, put this file in a different location, or change the file type, you must use the Save Asoption.

When you choose File/Save As, you can use the dropdown box at the top of the Save As dialog box, labeled Save in, to select the location where you want to save your new copy. You can also change thename of your new copy by using the File name input box and then either save it in a new location or in the same location as the original (because this new copy now has a different name). Furthermore, you can change the file type by selecting a new type from the dropdown box at the bottom of the Save As dialog that's labeled Save as type.

The main thing to remember is that Save will simply overwrite your existing file, whereas Save As will give you the chance to choose any of the options discussed above.

Ravi S replied to Phil on 04-Aug-11 10:16 PM
Hi

follow these steps

To save a file opened in Excel 2000 file as an Excel 2007 file, follow these steps: 
  1. Locate the file in Windows Explorer.
  2. Right-click the file, and then click Save As.
  3. In the Save As dialog box, click one of the following Excel 2007 file formats in the Save as type box, and then click Save:
    • Microsoft Office Excel 2007 Workbook (*.xlsx)
    • Microsoft Office Excel 2007 Macro-Enabled Workbook (*.xlsm)
    • Microsoft Office Excel 2007 Binary Workbook (*.xlsb)
  4. When the save is complete, click OK.

refer the link also

Riley K replied to Phil on 04-Aug-11 11:49 PM
If you are currently experiencing this problem with a file that you have not yet saved successfully, see the Save your Excel file before you start to troubleshoot the issue section before you continue to troubleshoot this problem.

If you want to know more about how Excel saves files, see the Process for saving an Excel file section.

To troubleshoot an Excel save issue, follow these steps in the order that they appear until the problem is resolved.

Step 1: Try to save the Excel file to another location


If you can save the Excel file correctly when you save it to a local hard disk drive, to a network drive, or to a floppy drive, the following are possible causes for the issues that you are experiencing: If you cannot save the Excel file correctly when you save it to a local hard disk drive, to a network drive, or to a floppy drive, the following are possible causes for the issues that you are experiencing: If neither of these are the cause, try step 2.

Step 2: Try to save a new Excel file to the original location

To save a new Excel file to the original location, follow these steps:
  1. Create a new Excel workbook.
  2. On the File menu, click Save As.
  3. In the Save As dialog box, follow these steps:
    1. In the Save in box, click the location where your original Excel file is saved.
    2. In the File name box, type a new name for your new Excel file.
    3. Click Save.
If you can save a new Excel file to the original location, the following are possible causes: If you cannot save a new Excel file to the original location, the following is a possible cause: If you have sufficient drive space, try step 3.

Step 3: Try to save the Excel file in Microsoft Windows Safe Mode


If step 1 and step 2 has not resolved the issue, restart Windows in Safe Mode, and then try to save your Excel file to your local hard-disk drive.