Excel Web Query against Sharepoint 2003 list

Posted on 2011-04-27
Last Modified: 2012-06-21
I am trying to run a excel 2003 web query against a 2003 sharepoint list where I have "read" rights but the query will not import the xls file. Do I need admin rights or what else would work.
I have run web queries against other sharepoint sites where I have admin rights without a problem.
Ant help would be appreciated
Question by:llawrenceg
    LVL 9

    Expert Comment


    I am not sure I understand your problem. Could you please provide more details?
    What exactly are you trying to do? And what is the error/issue that you encounter?


    Author Comment

    I am trying to run an excel 2003  web query to pull in an excel spreadsheet on a sharepoint list. The web query will refresh daily , copying the excel file to a preestablished sheet in a workbook. The excel sheet on the sharepoint list has 46,000 rows. When I run the query the excel file name cames through but not the data. I have admin rights to the list

    Accepted Solution

    I believe the problem is that the sharpoint link is too long ( more than 256 Characters) try shortening the link

    Author Closing Comment

    Answer discoverred  under google

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
    I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now