Forum Discussion

John_Borg's avatar
John_Borg
Copper Contributor
Jul 28, 2023

Excel Updates

Hi,

I am new here.

I have office 365 yearly subscription and I am assigned to office Insider. I am noticing that after my latest updates, I do not have the complete version of Excel. I.E. I do not see the Automate Button in the Main Tabs.

Adding to that, I have problems with the BYROW & BYCOL functions.

When I use the BYROW function, as below, when I type the L for lambda, I should see a dropdown.

i.e ByRow(range,L

1 Reply

  • John_Borg 

    Automate is for business and educational subscriptions only. If you are on consumer subscription you have no it.

    As for the function prompt it not always work, on other channels as well.

Resources