Forum Discussion
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?
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)
3 Replies
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)
- Muito obrigada NikolinoDE ! Foi muito esclarecedor!!!
- Estou feliz por ter podido ajudá-lo.
Desejo muito sucesso com o Excel.
