Problem: I have a jmp file that lives in a shared OneDrive folder. Other colleagues sync this OneDrive folder to their desktop so that we all have easy access to the shared jmp file. Inside the jmp file are links to other files that live in the same shared folder as the jmp file. Because each person has a user-specific OneDrive file path, my links are actually formulas which detect the user-specific file path to then set the user-specific appropriate link. Unfortunately, these formulas aren't automatically rerun when someone new opens the jmp file. I've explored two options to resolve this and am not a fan of either:
1. have a 'rerun formulas' script that you must run before using a link: unfortunately, people forget about this script. Furthermore, people commonly make subsets of the data and then try to run the 'rerun formulas' script but it doesn't work because formula evaluations are suppressed by default.
2. save a 'rerun formulas' script as 'OnOpen' so it runs as soon as someone opens the jmp table: unfortunately, this results in a prompt appearing (attached) and people are too scared to say 'yes' when it opens because they are afraid it'll ruin something (they don't even know what it's for)
Questions
1. Is there a way to make a hyperlink update as soon as it's clicked?
2. Can I suppress the 'OnOpen' pop-up or edit the pop-up to explain what the user should do?
3. Is there another way besides an 'OnOpen' script that would enable formulas to update as soon as a jmp table is opened?
Any help is appreciated. Thanks!
Matt
