Reporting with Excel Services : Using button and VBA. RRS feed

  • Question

  • Hi everybody.

    I try to make some sample report by using excel services.

    So, i began to create an excel file with some button and VBA code.

    then I go to the PWA / Business Intelligence / custom Folder / and then I click "add document".

    its upload the file correctly so I click on the document link to view if everything is ok.

    the result of the data connection is ok but none of my button appears even if they are generated with VBA code.

    i have this warning/error message :

    The following features are not supported in the browser and might not display or might display only partially: 
    • Comments, Shapes, or other objects 
    • VBA Project 
    Some features, such as external data queries, display cached data which can only be refreshed in the client version of Excel.

    Is there any solution to see my button? or execute my VBA code? Someone told me to investigate with digital signature and certificate but it didn't change anything.

    And in the Central Administration, then Excel Services, the box "Allow User Defined Functions" is checked.

    thanks about reading me and for your future help!

    just ask if you need something more.

    (Its project server 2010 - I tried with excel 2007 and 2010 even if I think that doesn't change anything)

    Tuesday, May 15, 2012 1:05 PM

All replies