Count without using macros or VBA

[Mr Otter]

My company has foolishly decided to use Microsoft 365 web edition. Because of this we are not able to use macros. This is because of SharePoint limitations. Is there a way to count how many times a cell is clicked without using VBA or macros? I should also mention this is being run as a shared document amongst several employees.
Any and all help or suggestions would be much appreciated

 

[ceranes]

No, there is no built-in feature in Excel 365 that allows you to count how many times a cell is clicked without using macros or VBA. However, you can use a workaround to achieve this by using the "HYPERLINK" function.
Here are the steps to follow:

1. Select the cell that you want to count the clicks for.
2. In the formula bar, enter the following formula:

=HYPERLINK("#count!A1",COUNTIF(count!A1,"x"))

Note: Replace "count" with any sheet name you prefer.

1. Press enter. This will create a hyperlink in the cell that, when clicked, will increment the count in another sheet.
2. Right-click on the sheet name tab and select "Insert" to create a new sheet.
3. Name the new sheet "count" and in cell A1, enter "x".
4. Return to the original sheet, and click the hyperlink in the cell you want to count. This will increment the count in cell A1 on the "count" sheet.
5. Repeat step 6 as many times as you want to increment the count.

Note: You can hide the "count" sheet to keep it out of view.

 

[RoryA]

@ceranes,

Have you actually tested this? It doesn't look like it could possibly work to me.