Hello All,

I'm trying to accomplish defining a parameter on a filter in excel 2010 and then Post it to SharePoint.  Once I post it to Sharepoint use current user filter and pass it to the excel sheet as the paramater. 

Any ideas how to do this without Pivot tables and just columns data? 

**Current Process:**

1) Access database pulling information from SharePoint Library

2) Creating Heat map Crossmap (see image below) & Exporting to excel

3) Adding formatting, blah blah

**Next steps:**

1) Like to upload excel export to SharePoint BI site & Filter on Current user parameter.  This will only show specific row information for that User. 

**Question:**

1) How do you setup filter parameter USING EXCEL 2010 and expose it to SharePoint?  I am not understanding the steps to accomplish this.  I'm looking to send Current user connection to excel sheet and only show that persons row of information but when I upload the excel sheet can't define a paramater. 

2) Can you name a FILTER as a parameter in 2010?

**Example:**

Any help would be appreciated and thank you for taking the time to read.

• Edited by DarkenSky 12 hours 53 minutes ago