My friend asked me for advice: He shares 6 workbooks on OneDrive with different colleges. Each of these workbooks use a common lookup table in a separate workbook. Without VBA, would it be possible to use the common lookup table shared on OneDrive. Each of the colleges should also have the rights to update the common lookup table.
All workbooks are shared on OneDrive.

Thanks in advance
HakanB