0

I have an Excel located in SharePoint Online Library. I tried using Intersect to detect any change or update in Column A, Column B will be updated to the month value of the change or update made in respective Column A.

It works well in Microsoft Excel Desktop App, but if I open the Excel in Web browser, the function not firing.

Pᴇʜ
  • 56,719
  • 10
  • 49
  • 73
James
  • 33
  • 6
  • The Excel web application cannot be automated with VBA. As far as I know, there is a Java Script API for this. However, I do not know any more details about this. https://learn.microsoft.com/en-us/office/dev/add-ins/reference/overview/excel-add-ins-reference-overview – Zwenn Mar 15 '23 at 12:52

1 Answers1

0

Check the function and/or formula/VBA. Things like "color" for cells are not available in the Online Excel, nor will VBA and macros work.

Kyle F Hartzenberg
  • 2,567
  • 3
  • 6
  • 24
PizSoto Diego
  • 1