SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

The Situation

I have a button that call{LIST_ID_REMOVED}&View={VIEW_ID_REMOVED}&CacheControl=1

In the SharePoint 2007 View itself, I only have 2 columns - Title and Description. However, when I click the button, it will open Excel with 2 more extra columns - Item Type and Path.


What should I do to the link such that when I click the button, it only show the 2 columns - Title and Description rather than 4 columns (which include Item Type and Path column)

share|improve this question
up vote 3 down vote accepted

Follow these steps:

1) Create a new file in notepad and copy in it:{LIST_ID_REMOVED}&View={VIEW_ID_REMOVED}

2) Save the file as owssvr.iqy (please note the extension)

3) Upload this file to a document library and use its link in the button instead.

share|improve this answer
I tried the same but it is giving me the error, "data could not be retrieved from the database check the database server or contact your database administrator. Make sure external database is available, and then try operation again. Sharepoint list export error" – Niranjan Kulkarni Jul 23 '15 at 9:43
How can i implement the same for sharepoint 2013 list – Niranjan Kulkarni Jul 23 '15 at 14:30

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.