Hi

I need dropdown column in powerpivot in excel 2013

How to achieve this.

• Moved by Lanlan HuangMicrosoft contingent staff 4 hours 56 minutes ago

Hi

This is the forum to discuss questions about Microsoft Excel develop (VBA, Automation). For your question is more about PowerPivot for Excel, I will move this thread to the PowerPivot forum.

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thank you for your understanding.

Best Regards

Lan

If your powerpivot is created, how about add a filter to achieve dropdown column.

Powerpivot :

https://msdn.microsoft.com/zh-cn/library/gg413497

And add filter you can try this Excel API,after download and add dll to your project you can refer the following code:

  Workbook workbook = new Workbook();
            workbook.LoadFromFile("DataTable.xlsx");

            Worksheet sheet = workbook.Worksheets[0];

            sheet.ListObjects.Create("Table", sheet.Range[1, 1, sheet.LastRow, sheet.LastColumn]);

            sheet.ListObjects[0].BuiltInTableStyle = TableBuiltInStyles.TableStyleLight9;

            workbook.SaveToFile("Filter.xlsx", ExcelVersion.Version2010);

REF:http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data/How-to-filter-data-in-Excel-in-C.html