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 Comma-separated value (CSV) files are often used as a way to exchange information between other programs and Excel. Sometimes you may get unwanted results when you open a CSV file in Excel, however. If you open a file and each record is in a single column, this tip can help you figure out why. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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

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 Excel is great at processing data, but sometimes your data processing needs may simply exceed the capacity of Excel. If you need to import more than 65,535 rows of data, you can’t do it directly in Excel. Instead, you’ll need to try one of the workarounds in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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

Problems with Dates?

Helpful Links

Great Info!

RSS Feeds