We help IT Professionals succeed at work.

Excel Web Query against Sharepoint 2003 list

llawrenceg
llawrenceg asked
on
567 Views
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
Comment
Watch Question

Commented:
Hi,

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

Commented:
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
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Answer discoverred  under google
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.