Solved

Perfmon.xla not working with my csv files

Posted on 2007-03-25
4
1,157 Views
Last Modified: 2013-12-01
Hi,

I'm trying to generate some nice graphs for a bunch of performance data I logged w/ Perfmon.

I've loaded the perfmon.xla into Excel 2003, I select Planning > Open > my.csv

and I get the following error:

Not a valid PerfMon CSV file. Make sure the file ends in the extension .CSV or it may not be properly parsed.

I've opened the CSV in Excel and all the data is there from perfmon, is this possibly something to do with perfmon.xla not designed to work with the windows 2003 perfmon?

If so... is there another alternative to generate the graphs?
0
Comment
Question by:mrwolf
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 45

Accepted Solution

by:
patrickab earned 250 total points
ID: 18791693
0
 
LVL 45

Expert Comment

by:patrickab
ID: 18791700
0
 
LVL 3

Author Comment

by:mrwolf
ID: 18797180
thanks but that wasn't helpful at all...
0
 
LVL 3

Author Comment

by:mrwolf
ID: 18797318
I figured out the best way was to just load the csv into the System Monitor and save as html using the graph perfmon generated...
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question