SOLVED

Missing Formulas and Functions in Excel

Copper Contributor

Hello guys.
The new formulas in Excel installed on Windows 10 are not appearing. 
For example, the TOCOL function is not appearing, and there might be some or many more formulas which are not showing up in Excel.
The below snip shows my Excel Version as on 23rd June, 2023.

vishaljhaveri_0-1687484920836.png

Version 2305 (Build 16501.20210) -> Latest version [attached a snip below and above]

vishaljhaveri_1-1687485472797.png

Can someone please help me on this?

1 Reply
best response confirmed by vishaljhaveri786 (Copper Contributor)
Solution

Hi @vishaljhaveri786 

 

Sample.png

You have Office 2019. Functions like TOCOL, TOROW, VSTACK, MAKEARRAY... are only available (as of today) in Microsoft 365 subscriptions 

1 best response

Accepted Solutions
best response confirmed by vishaljhaveri786 (Copper Contributor)
Solution

Hi @vishaljhaveri786 

 

Sample.png

You have Office 2019. Functions like TOCOL, TOROW, VSTACK, MAKEARRAY... are only available (as of today) in Microsoft 365 subscriptions 

View solution in original post