What I have is one workbook with 21 sheets. Within each sheet I have a VB add-in that query’s an oracle database and pulls values into the sheet. This workbook cannot be locked because if locked, the queries will not pull in the values. What I’ve done is hide this workbook in a place where other users can’t find it.
The users see 21 other separate workbooks and they use their workbook to update shift activities throughout a 12-hour shift. In their workbooks I will create formula’s to pull in values from the workbook doing the oracle queries and I can then hide the formulas.
If more than one person opens his or her workbook at the same time I’m sure someone will get a read only error when the workbook try’s to update values from the main workbook. Is there a way around this? Keep in mind that the workbook with the 21 sheets takes about 1 min to update after it is opened. So if code was written in a way that would open the main workbook first someone might get the read only error if it's within the one min or so it takes the workbook to refresh data. Maybe there is a way to write code on the individual workbooks to stall them if the main workbook is open?... I'm not real good at this stuff! I’m not sure what to do about this but if I can make this work, it might save my job!!
Bookmarks