Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Office 2000 Resource Kit
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
How to Share Files with Other Spreadsheet Applications
 
Upgrading to Excel 2000

You can customize Microsoft Office 2000 Setup so that it installs most converters that users need to share files with other applications such as Lotus 1-2-3 and Quattro Pro. If users need to open files created in other applications, and the file type is not listed in the Files of type box in the Open dialog box (File menu), then users must save the files in a format that Microsoft Excel 2000 can open.

Share text files

Excel 2000 users can open and save files in the following text formats:

  • Comma-separated values (.csv)
  • Data interchange format (.dif)
  • Lotus 1-2-3 space-delimited formatted text (.prn)
  • Symbolic link (SYLK)
  • Tab-delimited text (.txt)
  • Text (.txt)
  • Unicode text (.txt)

Because Excel 2000 is based on the Unicode text encoding standard, users can display text files correctly no matter what language the files were created in, as long as users’ computers are running an operating system that supports the characters particular to that language.

Import files by using the Text Import Wizard

Excel 2000 users can use the Text Import Wizard to import text files and parse text across columns. You run the wizard by opening a text file and following the instructions that appear on the screen.

Open HTML files

When users open HTML files, the files are opened in the applications in which they were created, rather than in Excel. Excel 2000 users can open HTML files created in other applications in Excel by right-clicking the file in the Open dialog box (File menu) and then clicking Open in Microsoft Excel on the shortcut menu.

See also

If Excel 2000 users share workbooks with users of other applications, you can change the default format in which Excel 2000 saves workbooks. For more information, see How to Specify the Default Format in Which to Save Files.

Office 2000 includes several new international features that help simplify the task of administering and supporting Office internationally, such as Unicode. For more information, see Overview of International Features in Office 2000.

Office 2000 includes new and enhanced HTML features for publishing workbooks to your intranet or the World Wide Web. For more information, see Taking Advantage of Office Web Features.

advertisement