Microsoft KB Archive/211713

= XL2000: Using Microsoft Excel to Save a File to an FTP Site =

Article ID: 211713

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211713





SUMMARY
In Microsoft Excel 2000, when you save a workbook or any other file to a File Transfer Protocol (FTP) site, the name of the file is not always case sensitive. Therefore, you may inadvertently overwrite another file.

This article contains information about using Microsoft Excel to save files to FTP sites.



How to Save a File to an FTP Site
To save a file to an FTP site, follow these steps:  On the File menu, click Save As. In the File name box, type the path to the FTP site. For example:

ftp://myftp

Press ENTER. Type the name of the file (myfile.xls, for example) in the File name box, and click Save.

NOTE: You can combine steps 2 and 3 into a single step by typing the complete path to the FTP site and the file. For example, you can type the following in the File name box

ftp://myftp/myfile.xls

and press ENTER.

Saving a File When a File with the Exact Same Name Exists
When you save a file to an FTP site, Microsoft Excel 2000 determines whether a file with the exact same name already exists in that location. If such a file exists, you receive a warning message similar to the following:

The file 'ftp://myftp/myfile.xls' already exists. Do you want to replace the existing file?

If you click Yes, the existing file is replaced. If you click No, the Save As dialog box opens again. This is normal behavior in Microsoft Excel.

Saving a File When a File with a Similar Name Exists
If you save a file to an FTP site, and the FTP site already contains a file that has a name that is the same as the new file except for case, you do not receive a warning message.

For example, if the FTP site ftp://myftp already contains a file named "myfile.xls", you will not receive a warning message if you save a file named "MYFILE.xls" to the same location, because, technically, the file names are different.

However, the original file may be overwritten by the new file. This problem may occur if your FTP server is running Microsoft Windows NT version 4.0 or earlier, or any other operating system that does not support case sensitivity in file names.

NOTE: This problem does not occur when saving files to an FTP server that is running UNIX.

Following the example shown above, the new file "MYFILE.xls" may overwrite the original file "myfile.xls". To prevent this problem from occurring, make sure that your file names differ in some manner other than case; for example, add one or more other characters to the file name, so that it is unique.

Additional query words: File Inadvertently Overwritten Saving to FTP Site XL2000

Keywords: kbhowto kbweb KB211713

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.