I have an application that has a trigger set on Open at both document property level and Sheet property level.
The triggers work fine on the desktop. However, they don't function on the server.
Could you all please suggest an alternative to this trigger setting.
I have set the trigger on Open as : Month =Month(Max(StartDate)) . The requirement is for the application to pick up the latest month based on Star-tDate.