+ Reply to Thread
Results 1 to 3 of 3

"GET EXTERNAL DATA" Feature Does not Work

  1. #1
    Registered User
    Join Date
    11-05-2013
    Location
    United States
    MS-Off Ver
    Excel 2007 Small Business
    Posts
    3

    Question "GET EXTERNAL DATA" Feature Does not Work

    From MS Excel 2007 (small business edition) I am unable to connect to any external data sources. This includes both Access files and SQL Server connections.

    I have verified that I can link to those databases from another computer, and the main difference is when I click to connect, Excel actually appears to be trying to connect (and is then successful) whereas from my PC there is an immediate "Unable to Connect to Database" error in the case of MSSQL (for Access there just is no dialog that appears)

    I have searched extensively for a solution on the web but have found no successful suggestion (including repair of office, dropping firewalls, changing connection parameters, file versions, etc..)

    Does anyone have any idea what it could be? I went through the settings meticulously between the working PC and the non-working PC and made all the settings exactly the same, but nothing helps

  2. #2
    Registered User
    Join Date
    11-05-2013
    Location
    United States
    MS-Off Ver
    Excel 2007 Small Business
    Posts
    3

    Re: "GET EXTERNAL DATA" Feature Does not Work

    Is there any sort of diagnostics I can use to see what's happening when an external data source is selected?

  3. #3
    Registered User
    Join Date
    11-05-2013
    Location
    United States
    MS-Off Ver
    Excel 2007 Small Business
    Posts
    3

    Re: "GET EXTERNAL DATA" Feature Does not Work

    what, nobody?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. "Windows in Taskbar" feature does not work
    By rm999 in forum Excel General
    Replies: 3
    Last Post: 07-13-2008, 09:28 AM
  2. [SOLVED] "Show Placeholder" feature in options/view doesnt work
    By in forum Excel General
    Replies: 1
    Last Post: 01-07-2006, 11:10 AM
  3. [SOLVED] "Show Placeholder" feature in options/view doesnt work
    By in forum Excel General
    Replies: 0
    Last Post: 01-05-2006, 10:50 PM
  4. [SOLVED] "Show Placeholder" feature in options/view doesnt work
    By in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2006, 10:50 PM
  5. excel: external data "data range properties" button dosent work
    By HelpMuchNeeded in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1