Right click does not work in Excel formatted table - Microsoft Community

the right click function not work in tables have formatted data table (rather data range)

i've tried uninstall-reinstall same. i've read code type in etc has no effect on formatted table

help please?

thanks in advance

hi liz123lb,

based on description, issue occurs on normal cells.

i suggest try right click on other programs check if issue occurs.

we need check if issue related mouse.

besides, can try safe mode check if issue related add-ins.

you can refer following article:

open office apps in safe mode on windows pc

if issue still exists, please provide version of office? (click file>select account)

thanks,

qing

hi again qing

i've found out there issue macro running in background spreadsheet did not close properly. protecting paprts of sheet...

we looked @ add-ins , there seemed ones there other sheet. opened sheet again , closed , problem went away!

thanks of advice , time replying. 

liz

Office / Excel / Windows 10 / Office 365 for business