::: Excel tips 8 :::

>> Update for Excel 2000 text export <<

Microsoft has released a patch that fixes a formatting problem when exporting Excel 2000 files to .txt documents. On machines running a Microsoft OS earlier than Windows 2000, four-digit year entries are automatically truncated to two-digit entries, regardless of formatting applied within Excel.
This behavior occurs only when users employ a macro or procedure to export to a text file, not during manual saves to a text file format. If your users are using Visual Basic for Applications to export files to .txt, .prn, .csv, or .dif formats (and you are using a pre-Windows 2000 OS), you need to install an update released by Microsoft. For more information, read the Microsoft Knowledge Base article 247796, XL2000: Programmatically Exporting Text File Truncates Dates:
http://support.microsoft.com/support/kb/articles/Q247/7/96.asp

----------------------------------------------------------------------------------
>> Creating a workspace in Excel <<

Often, your users will be working with several workbooks at a time. They will be happy to know that they can arrange the workbooks, save them as a workspace, and then open everything at once in the viewing configuration they prefer. Here's how:
. With all the workbooks in the preferred positions, go to the File menu.
. Choose Save Workspace.
. Type a name for the file.
. Click Save.
The next time your users want to work with those workbooks, they can go to File | Open and select their workspace.