Topic: Working with Other Programs

The following are additional topics related to the category listed above. A bracketed number after the topic indicates how many articles are related to that subject.

Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Changing Links If you’ve got information linked into a workbook, you need to know how to change those links. Why? Because the source of that linked information may have changed. Use the technique described in this tip, and you can make the changes quickly and easily. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

CSV File Opens with Data in a Single Column When you import a CSV file into an Excel worksheet, you may be surprised at how the program allocates the information among columns. This tip explains how Excel figures out what goes where. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Exporting from Excel to AutoCAD If your office uses AutoCAD, you may wonder how you can get information stored in Excel into your AutoCAD drawings. There are known limitations to placing Excel worksheets into AutoCAD drawings, as discussed in this tip. Here you’ll also find some suggestions on ways to work around the limitations. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

File Formats that Include Field Formats If you import data into Excel that is created by other programs, you know that it can be bothersome to get your data formatted correctly. This tip discusses text-only file formats (such as CSV) and whether you can specify individual field formatting in the file. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Ignoring Other Applications If Excel is giving you problems when working with other applications, you may want to configure Excel so that it doesn’t share information with other programs. Using the Ignore Other Applications check box as described in this tip does the trick. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Importing Huge Data Files Sometimes, when importing data created by other programs, you may find that there is too much for Excel to handle. Here’s how you can still accomplish the task. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Working with Lotus 1-2-3 Spreadsheets Lotus 1-2-3, a spreadsheet program popular before Excel came on the scene, treats data in a worksheet differently than Excel does. This tip provides information on how you can configure Excel to better approximate the way that Lotus 1-2-3 handles data. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

More Topics

Tips, Tricks, and Answers

Save Time!

Helpful Links

Great Info!

RSS Feeds