When you import a .csv event log file into Excel 2007 on a Windows Server 2008-based computer, the event log is not readable

Article translations Article translations
Article ID: 949390 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

You can save an event log as a .csv file on a Windows Server 2008-based computer. However, when you import the event log into Microsoft Office Excel 2007, it is not readable.

WORKAROUND

To work around this problem, follow these steps:
  1. Save the event logs in Event Viewer in .csv format. To do this, follow these steps:
    1. Start Event Viewer. To do this, click Start, click Run, type eventvwr, and then click eventvwr in the Programs list.
    2. Click to select the event log that you want to save.
    3. On the Action menu, click Save Events As.
    4. Type a name for the log file in the File name box.
    5. In the Save as type field, click to select CSV (Comma Separated) (*.csv), and then click Save.
  2. Open the file that you saved in step 1e in a text editor, such as Notepad.
  3. Save the file. Click Yes if you are prompted to replace the file.
  4. Double-click the .csv file that you saved in step 3, and then open the file in Excel 2007.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 949390 - Last Review: March 26, 2008 - Revision: 1.1
APPLIES TO
  • Microsoft Office Excel 2007, when used with:
    • Windows Server 2008 Datacenter without Hyper-V
    • Windows Server 2008 Enterprise without Hyper-V
    • Windows Server 2008 for Itanium-Based Systems
    • Windows Server 2008 Standard without Hyper-V
    • Windows Server 2008 Datacenter
    • Windows Server 2008 Enterprise
    • Windows Server 2008 Standard
Keywords: 
kbtshoot kbexpertiseinter kbprb KB949390

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com