This is a discussion on Worksheet / Workbook on a server within the Excel Questions forums, part of the Question Forums category; Hi all, I have a workbook that has a userform with comboboxes that references a worksheet to fill the boxes. ...
I have a workbook that has a userform with comboboxes that references a worksheet to fill the boxes. The reference worksheet is updated frequently and in order to make the most current sheet available to everyone I wanted to centralize the data on our server. I tried putting the entire workbook on the server so you could log on to the server and run the workbook from there, but that didn't work. I thought about putting just the worksheet on the server but I'm not sure how to link all the workbooks to the sheet. I have had trouble in the past linking my VBA references to things that have been moved.
I have read a couple of threads in the archives about servers but most of those questions seem to be geared towards several people working a project and having access to workbook. I would think this is a fairly common requirement for offices - can anyone shed some light on the subject.