Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

Categories

Archives

Learn how to create Excel dashboards.

Excel Twitters 20090103

Moved to the Excel Twitters archive:

Excel Twitters 20090103

5 comments to Excel Twitters 20090103

  1. Roger Govier
    January 3rd, 2009 at 5:09 am

    Happy New Year, Deb.

    Not sure I follow the problem with csv file.
    Just created a file in Excel and saved as id.csv
    No problems saving or reopening.

    Also tried making id the first entry on sheet and saved, still no problem.
    What do you need to do to re-create the problem?

  2. Tom Gleeson
    January 3rd, 2009 at 8:06 am

    I too can't replicate the "id" CSV problem (using Excel 2003).

    I like the ...

    "user was complaining that excel 2007 has ‘less functionality’ than prev vers. turns out no one @ his last job knew about the office button"

    ... first time I encountered Excel 2007 (with a paying client looking on) it took me a few minutes to figure out that the Office button actually did something.

    Tom

  3. Dave
    January 3rd, 2009 at 8:33 am

    The first two characters in the file (ID) is how excel (and other programs) know that you're working on a SYLK file.

    What the heck is that?
    http://en.wikipedia.org/wiki/SYmbolic_LinK_%28SYLK%29

  4. Debra Dalgleish
    January 3rd, 2009 at 9:03 am

    Thanks Dave! I've added the link to the top of the article.

    Roger, Happy New Year to you too! The ID must be in capital letters for this problem to occur.

    Tom, use ID instead of id and you should see the problem. I related to that Office Button comment too. It just looks like a nice decoration when you first see it.

  5. Jan Karel Pieterse
    January 5th, 2009 at 8:18 am

    Happy new year deb!

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>