Shared File References Update

Hello,

I'm working on shared files I created for multiple people to access on multiple computers (same type of computer, same excel 2016 software). It was working fine with the group I tested on, but as more people tried to use it, They’re getting an error that there is a problem within a hidden module. When I unshared to check it out on their computers, it said “Compile Error: can’t find the project or library”.
When I was writing the code, I had turned them on in VBA references—and like I said, it worked on some people’s computers—but for anyone getting that error, do I have to make them each, in turn, unshare and I go through and re-setup the references? Or am I misinterpreting the problem?


Thank you!
J.S.

Thanks, this does help. I know these shared workbooks aren't a long term solution, but I'm using them as a band-aid until I can get something that'll allow me to organize this particular project the way I need to. Unfortunately a master workbook wouldn't work for that, but thank you!