Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

The Situation

I have a button that call http://mywebsite.com/subsite/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={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.

Question

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

1 Answer 1

up vote 3 down vote accepted

Follow these steps:

1) Create a new file in notepad and copy in it:

http://mywebsite.com/subsite/_vti_bin/owssvr.dll?XMLDATA=1&List={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

Your Answer

 
discard

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.