As a short answer: No. There is no such parameter to export a list or Library to Excel / CSV from URL. Behind clicking on Export List to Excel from the above ribbon, you will get a URL like http://your site /_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={638D72C3-264C-4797-9812-67544942EFEB} This link requires at least the List ID, and ...


No, it's not possible as Excel drop-down lists do not support multiple choices. It has nothing to do with SharePoint or with your list, but it's a known limitation of Excel. A workaround would be to use Access instead of Excel.


Sounds like you could manually copy the calculated column data from Sharepoint to Excel instead? (Unless you have so much data that this would be impractical). Otherwise you could recreate the calculated column in Excel. The problem with calculated columns is that they need all the columns used in the calculation to be present; when the data is sent to ...

Only top voted, non community-wiki answers of a minimum length are eligible