Regarding SharePoint and Excel file with VBA/Macro (Excel Web Services)

1
votes

I am new to Excel Web Services in SharePoint..

I created an excel sheet with calculated column. Uploaded the doc to SharePoint. Added the doc on web part page along with a choice filter web part. The calculated column updates it self based on the value passed to other cell by the filter web part.

Then, I created another excel sheet with vba code/macro. It is supposed to filter the excel table based on value entered in say col4+row1. This works in excel. Uploaded the doc to SharePoint. Added the doc on web part page along with a choice filter web part. The value gets passed to col4+row1. However, code that filters the sheet wont run in SharePoint!

Is it true that SharePoint does not support vba/macros? If so, is there any other alternative to achieve filtering functionality of excel sheet in SharePoint?

UPDATE 1: I am doing some research on SQL Server Analysis Services and DAX, here is a tutorial. I do not know if this can be used in SharePoint, but I will try this way..

1
sharepoint
Yes, SharePoint does not execute macros - you can upload them just fine, but it doesn't execute them. Have you considered adding SharePoint metadata for filtering? – Dennis G
Can you point me to some reference links to try this, please... – variable
Go to your list settings, add a few columns and filter by these. There is no easy out of the box solution which fills these based upon some value within your Execl files. – Dennis G
OK, I am looking for solution based on excel and not the list based filtering! This is because we already have excel files that need to go on the server and we need to use excel web service in SharePoint. I know that there is no easy solution and that's the reason I have come to this forum to get pointers to what the possible solutions are.. – variable

1 Answers

-2
votes

try fillter and then your done. Easy as pie!