Forum Discussion

AdrianaM73's avatar
AdrianaM73
Copper Contributor
Dec 29, 2021
Solved

Como segmentar dados no Excel para Web?

É possível criar segmentação de dados no Excel para Web para colocar em um dashboard? É possível habilitar a guia Desenvolvedor no Excel para Web? 
  • NikolinoDE's avatar
    Dec 30, 2021

    AdrianaM73 

    Excel for the web allows you to use slicers created in desktop versions of Excel, but does not support creating slicers, editing slicers, or selecting multiple values in a slicer.

     

    Excel 365 supports VBA as a desktop version, but not as a web app.

    Work with VBA macros in Excel for the web

    Although you can't create, run, or edit VBA (Visual Basic for Applications) macros in Excel for the web, you can open and edit a workbook that contains macros. Any existing macros will remain in the workbook, and you can open the workbook in the Excel desktop app to view and edit the macros.

    Explanation: VBA is processor and memory model dependent and can therefore not, like other programs, run in a browser on every system. That would only work if there was a virtual layer between VBA and the machine language. However, VBA (and C ++) are so fast because this layer is missing. - Since I am not a computer scientist, these assumptions can be wrong.

     

    Hope this information could help you.

     

    Wish you a nice day.

    Nikolino

    I know I don't know anything (Socrates)

     

Resources