Monthly Archives: January 1998

Appraised At Current Value

As taken from the personnel files of employees in a large US corporation: “Since my last report, this employee has reached rock bottom..and.. has started to dig.” “His men would follow him anywhere, but only out of morbid curiosity.” “I … Continue reading

Posted in Humour | Tagged | Comments Off on Appraised At Current Value

Web browser error messages

In Microsoft Office 97 for Windows (or Excel 97, Word 97, or PowerPoint 97), if you use the Microsoft Web browser control to go from one document to another of the same kind, you may get one of these error … Continue reading

Posted in Spreadsheets | Comments Off on Web browser error messages

Counting down days

Version 4.x, 95 – If you’d like to know how many days left until St. Patrick’s day, run Excel and type =”03/17/98″ – “01/15/98” ‘ or today’s date into a cell. Excel will return the number of days (61) between … Continue reading

Posted in Spreadsheets | Comments Off on Counting down days

Using delimited files

Version 4.x, 95 – There are times when you might need to use an Excel file in some program that doesn’t use Excel files. If this happens to you, check to see what kind of files the program will handle. … Continue reading

Posted in Spreadsheets | Comments Off on Using delimited files

Date formatting options

Version 4.x, 95 – You can do more with Excel’s date formatting than you might think. Suppose you’d like a particular cell to show only the month and the day. Click the cell (to select it) then choose Format, Cells … Continue reading

Posted in Spreadsheets | Comments Off on Date formatting options

Access linking limits

Links go only so far between Access and Excel. If you create a link table in Microsoft Access 97 that links to a worksheet in an Excel 97 for Windows workbook, be careful. If you change a value or values … Continue reading

Posted in Spreadsheets | Comments Off on Access linking limits

Notes incompatibility

Here’s the latest chapter in the long-standing, barely veiled reluctance of Lotus and Microsoft to make their programs work well together. Lotus has confirmed that there is a potentially serious problem when using Lotus Notes 4.x’s viewer for Excel files. … Continue reading

Posted in Spreadsheets | Comments Off on Notes incompatibility

Disappearing office assistant

It’s hard to get good help these days. If you put an object into an embedded Microsoft Excel 97 for Windows workbook that’s open in Netscape Navigator 3.0, you’d better not need any assisting, because the Office Assistant help program … Continue reading

Posted in Spreadsheets | Comments Off on Disappearing office assistant

Automatic recalculation algorithm

Microsoft Excel 97 for Windows’ automatic recalculation algorithm may not work in worksheets other than the active one, according to reports from PC Week Online and InfoWorld Electric. The kicker is that there’s no error message, so data could Males, … Continue reading

Posted in Spreadsheets | Comments Off on Automatic recalculation algorithm