Problem with opening multiple instances of file on a network

dpaton05

Well-known Member
Joined
Aug 14, 2018
Messages
1,112
I have been creating several spreadsheets at work and there is a problem with opening more than 1 instance of them at the same time on a network. I have one spreadsheet called "quoting tool" that generates quotes. When quotes are finalised they are sent to separate spreadsheets called allocation sheets. The allocation sheets are for each financial year.

The problem I have is person A might have the quoting tool open that may have an entry in it within the 2019-2020 financial year. Person B might have the 2019-2020 financial year allocation sheet open on their computer. Person A is happy with the quote and press a button to transfer to the allocation sheet and it transfers to the 2019-2020 allocation sheet, save it and close it. Person B then manually adds an entry then saves it.

Because person B already had the allocation sheet open when person A made the quote and added it to the allocation sheet, saved it and closed it, if person B then makes a manual change to the allocation sheet and saves it, it will overwrite any change that person A had made.

I think I explained that. I don't know what to do to fix this, or if I can fix it. Does anyone have any ideas?
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,193
Office Version
2013
Platform
Windows
I don't have Excel at the moment, but I'm guessing the only option available is to check, when the transfer to allocation sheet button is pressed, to see if the allocation workbook is open, and if it is display a warning to the user and maybe get them to wait x minutes before retrying.
Have a look here

https://www.mrexcel.com/forum/excel-questions/10398-vba-check-if-workbook-open.html
and also here, for on a network

https://www.ozgrid.com/forum/forum/help-forums/excel-general/62861-is-file-open-on-network
 

Forum statistics

Threads
1,082,132
Messages
5,363,340
Members
400,727
Latest member
Raynman

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top