Can't create list from Excel Workbooks in STS

From: Mike (Mike_at_discussions.microsoft.com)
Date: 11/27/04

  • Next message: Mike Walsh: "Re: Can't create list from Excel Workbooks in STS" 
    Date: Sat, 27 Nov 2004 09:29:02 -0800

    I use to be able to do this. I assume some update is now preventing it.
    When trying to Create a list from Excel File, the Visual Basic
    Debugger opens with an error saying "Compile Error: User defined
    type not defined". When I exit the debugger, I end up back at the "Create
    New List" screen where I began, and then get a Microsoft Internet Explorer
    dialog saying "!An unexpected error has occurred. (-2147215003)" OK.
    I look this (-2147...) error up and found it indicated Microsoft Visual
    Basic was not properly installed. Followed instructions to fix but didn't
    solve the problem. I didn't expect it to since having VB installed isn't a
    prerequsite to using STS anyway.
    This problem exist on all sites hosted by two seperate file servers. I have
    tried accessing the sites from both an XPHome and Windows2000 workstation.
    I've tried importing different workbooks. I've read many suggestions on how
    I
    might change the Workbook settings but nothing I do makes the error go away.

    Overview of my system: My servers and workstatoins are completely patched
    upto date. Windows2000 Server, Office XP Professional, Frontpage2003:
    I think this may have started after installing Frontpage2003 on my
    workstations.
    I have been using FP since 1997 and updated each year. The FP2003 is quirky
    with STS on Windows2000server. Many FP2003 features can't be used with STS;
    for instance I coculd publish a site to another server using FP2002 but can't
    with FP2003. FP2003 has not been installed on either of the file serves.
    Just the workstations I'm trying to access sites with have FjP2003. Hmmm.
    think I'll go find a PC without Frontpage and try this there.

    Any help is greatly appreciated.
     
     

  • Next message: Mike Walsh: "Re: Can't create list from Excel Workbooks in STS"

    Relevant Pages

    • Re: Cant create list from Excel Workbooks in STS
      ... with STS are those that have been added to FP 2003 for WSS) is installed, ... > This problem exist on all sites hosted by two seperate file servers. ... > I think this may have started after installing Frontpage2003 on my ... > Just the workstations I'm trying to access sites with have FjP2003. ...
      (microsoft.public.sharepoint.teamservices)
    • Re: Best Practices Survey: Disk Partitioning
      ... >> Are we talking about servers or networked workstations? ... >> you should already have a procedure for installing it. ...
      (comp.os.linux.security)
    • IT Security Administrator in Bend, OR
      ... workstations as well as physical security for I/T systems. ... manages network security software and hardware. ... Extensive experience with Windows 2000/2003 servers and Exchange ... Two years experience configuring, installing and implementing VMWare ...
      (comp.arch)
    • RE: Optimize SMB on server to accomodate slow WAN link
      ... The lack of bursting is really a function of the carrier, ... especially if you have servers in the ... Advertising of shares/printers by workstations and servers ... the central office that they do not need to be connecting to. ...
      (microsoft.public.win2000.networking)
    • Network Administraot in Bend, OR
      ... Determines, installs and manages network ... Troubleshoots and configures Casino phone networks and servers to ... AUTHORITY & RESTRICTIONS (supervisory capacity, signatory ability, ... Three years experience configuring, installing and implementing HP ...
      (comp.sys.mac.system)