Can't open BOM in Excel

Discussion in 'SolidWorks' started by Count Zero, Nov 5, 2003.

  1. Count Zero

    Count Zero Guest

    Using SWX 2004 and Excel 2000 SR-1

    About an hour ago I could double click on a BOM in a drawing. It opened up
    (excel style) so I could copy the content to excel. But now everytime I
    double click on the BOM it opens just one cell. Right click doesn't give me
    an 'edit' possibility. I uninstalled excel and reinstalled. For some reason
    the same problem exists with a colleague. Is it the combination Excel 2000
    and SWX2004. I restarted several times, also between installations.

    Thx.
     
    Count Zero, Nov 5, 2003
    #1
  2. Count Zero

    Krister L Guest

    Can't really say where Your specific problem comes from, but if You just
    need to get Your bom into a new spread sheet, all You need to do is
    highlight it, go to file on the menu and pick save as, this will save Your
    bom as an excel-file.

    Krister
     
    Krister L, Nov 5, 2003
    #2
  3. Count Zero

    Count Zero Guest

    Sorry, but no. If I highlight the table (or rightclick > select > table) and
    go to File > Save As, I can only save as bom template, txt or cvs.

    It looks like SW doesn't recognise that Excel is installed.
     
    Count Zero, Nov 5, 2003
    #3
  4. Count Zero

    Krister L Guest

    I tried a few drawings here and it works as always ....SW2004 and Excel
    2002....even old files saved with Excel 97.

    Krister
     
    Krister L, Nov 5, 2003
    #4
  5. Hi Folks,

    Let's not loose sight of the real situation with the new BOM. It's
    still in BETA, not in production release.

    It will not be released for production until sometime around the 2004
    SP 5.0 timeframe - q3 of 2004 perhaps.

    (for anyone who has not appreciated the sarcasm, please be advised
    that the above diatribal proclimations are perhaps possibly not true.)

    Desperately in need of (at least) a CSV or tab-delimited output,
    preferably an OLE to excel or save as XLS.

    Are we really expected to retype all that stuff when we need to load
    data into MRP?

    Do we hit the way-too-big-table formatting next . . . Or the MANDATORY
    config name prependment to QTY in the column name . . . Or maybe the
    apparent inability to alter bom item numbers by clicking the callout
    balloons . . . or . . . or . . .

    I can't wait until all the oddities are addressed. It all looks
    promising, but that's all right now - too many quirks to navigate to
    be really usable . . .

    My greatest fear -> SW pronounces it "complete" and ignores the many
    stumbling blocks, ignoring the excel BOM as legacy code and not making
    it the tool it needs to be.

    Regards-

    SMA
     
    Sean-Michael Adams, Nov 6, 2003
    #5
  6. Hi Deb!

    Thanks for pointing out my serious lack of knowledge in such a
    pleasant way. I'm still getting used to the differences here and the
    file "save as" was not very obvious to me.

    I would have "gotten it" if the save-as was built into the RMB, but I
    can adjust.

    The raw output to text worked very well, while the CSV was ok, but
    only because I have commas in the description was it unworkable when I
    input into excel.
    Yes - I second that. After about 4 tries I got Sp 1.0 installed and
    have seen a few better things. The BOM is now sizable (it may have
    been before) by dragging the corners, the config name prependment in
    "qty" may be manually overridden and is persistent (was not before),
    the balloons act like they used too (double click) makes the BOM
    update. Progress is being made. My faith is restored. That was
    easy.
    I agree. In so many ways it rules - my carpal tunnel / tendon trouble
    is at bay - more design - less drafting. Secretly though, I still use
    ACAD for some things because it works better for some 2D applications,
    but I must confess that my T-square sees about as much action as my
    Diazo machine (I see one "response" to your message that claims that
    the t-square beats acad).

    Thanks again for gracefully schooling me (smile).

    Regards,

    SMA
     
    Sean-Michael Adams, Nov 9, 2003
    #6
Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.