shared workbook

Hello! I have gotten so much help from this board and I do not feel the greatest where my first contribution is in the form of another question/problem, but now that I am here, who know!? I will try and keep it short. I have built an Excel-based scheduling tool with a custom ribbon in a shared...

Hi All, Ive searched and searched and cant find an answer to my query. If it has been answered already please point me in the right direction. I have a shared excel workbook where multiple staff could be in at the same time. Staff input and update data via a userform. To populate the excel...

Hi, I use this code (see below) to collect data from 4 different worksheets into a central worksheet called ß_PCF. It works well, but it's a bit slow. It usually takes around 10 seconds. It should be noted that this code runs in a shared and locked workbook. Would it be possible to run it...

Hi, i have developed the following architecture to manage and report on the bidding process: - a workbook that generates quotes in a CPQ format, deployed on the salespersons local machine - after the bids are finalized the salesperson automatically uploads the quote in a centrally hosted...

Dear All, Following code is to highlight the Row in the given range when a cell is selected. This codes works perfectly alright until the time the workbook is Shared. "Application defined or Object defined error" is shown when the workbook is Shared. Private Sub Worksheet_SelectionChange(ByVal...

Dear All, I have a workbook which has to be shared between 3 to 4 people, who will update data at the same time. but depending on the user opening the file, certain sheets to be hidden and visible. How do i achieve the same. Kindly suggest. Regards Krishnamoorthy S

Hi, I have created a client manager in excel 2013 at work which uses the shared workbook feature. I need to use drop down lists so all the data validation needs to be set up before i share the workbook. If we make any mistakes we have to unshare the workbook, copy and paste the 'data validation...

Hi, I have a shared workbook where there will be many users working together simultaneously. Lets say users are "A", "B", "C", "D" and so on. I want to code the file such that user A can only access the spreadsheet that is to be worked by him and other users should not have edit/delete access...

Office 2010, Windows 10, An Excel Shared workbook being used by 12 Users stored in a shared folder on the network server. The issue is when a user tries to save the workbook after making their changes, they get the following error message. Then they have to close the file and lose their...

Hi, I have a shared workbook with the option of autosave and update set to every 5 minutes. I would like that after an auto update and save if a user modified a specific cell a message box will appear. I have already tried Worksheet_Change(ByVal Target As Range) and Worksheet_Calculate()...

Hello, I have searched high and low but to no avail. Please can anyone help...? :confused::confused::confused: I have built a user form in excel, which I need to be updated by multiple users, so I have shared the workbook. Upon clicking 'Save' the date is transferred to the next available line...

We have been using a shared workbook with various tabs (excel 2010 - now 2013) for about 6 months now without any issues. However, 1 of the 6 users reported today that when she opens the shared workbook, she now can only see data from 2 months ago - not the most recent version (even though she...

Hi all Is there a way to run a user form in a shared Workbook??

Hi All Is there any way to keep your Macro's (VBA) enabled on a shared workbook???<strike></strike>:confused:

I have an excel workbook which has several VBA forms with macros running to handle the information inserted by the user. Everything runs well until I define the workbook as shared, allowing others to make changes to it. Once defined, one of the forms aborts with the following error: 'Run time...

I am completely new to VBA, but from what I know it seems this should be possible. Could anyone please walk me through how (and where) to enter a VBA that will automatically save the shared workbook any time any user changes any cell. The practical application is that I have a PO log that...

Dear All, From the web link : https://support.office.com/en-nz/article/Use-a-shared-workbook-to-collaborate-b8207fe9-a613-483f-b804-0ca4658b0c61 I have understood that the SHARED WORKBOOK feature in Excel, allows multiple user to read and write on a single EXCEL Workbook kept on a common...

Hello fellow Excel guys, I'm a developer for my company, and we use a shared workbook which is accessed by several people through the day. It relies heavily on VBA (so much so that I have separated out the code into an .xlam add-in which is referenced from the main file, in order to keep the...

Hello, I'm having a huge problem with a shared workbook that is being used by a few people at my office. I created a template which is used to SaveAs a new workbook each day. This workbook is shared and was working fine up until a week ago. Now every time a second user tries to open the...

Hi All, I'm wondering if someone can help, I have a shared workbook that I've added the below code to so that it automatically saves and closes if someone has it open for 30 minutes and hasn't used it (it was constantly annoying people leaving it open all the time!!) :banghead: It works...