What I have is one Workbook serving as a Data Entry form. That form populates another Workbook that serves as a Database. From that database, I have a third Workbook that I have data connections in back to the database to analyze the data in different ways (Pivot Charts, etc.)
The problem I have is if the Analysis Workbook is open on another user the Data Entry Workbook cannot simultaneously enter data and save the changes to the Database Workbook. Hopefully this makes sense. I do not know if there is a solution to this issue. Any help would be greatly appreciated.
The problem I have is if the Analysis Workbook is open on another user the Data Entry Workbook cannot simultaneously enter data and save the changes to the Database Workbook. Hopefully this makes sense. I do not know if there is a solution to this issue. Any help would be greatly appreciated.
