Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #21  
Old 05-08-2018, 10:54 AM
ArviLaanemets ArviLaanemets is offline Dropdown select worksheet to point data? Windows 8 Dropdown select worksheet to point data? Office 2016
Expert
 
Join Date: May 2017
Posts: 950
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

When thy need to access it to read information it is OK. For this the sharing is not needed.

When sharing is used, then several users can open the workbook simultaneously, the user who opened the workbook as first locks it, and when first user closes workbook, the next user can save changes (at least it was something like this until Excel2016 - now MS made changes to this feature I am not familiar with at all).

When the workbook is not shared, any number of users can open it simultaneously too, but none of users opening it as 2nd or further simply can't save it. In case only one user/a couple of users is entering new contacts, the only problem will be the workbook being locked for this contact info administrator, when someone else is looking for info at same time.

A possible solution is to have a master workbook, where contact info is entered by contact info administrator. and every non-administrator user has his/her own workbook, which reads contact info from master workbook using ODBC query, which is refreshed whenever the workbook is opened, or when the user refreshes the query at will. With this design, the Master workbook is always available for editing.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking to copy select cells in table using dropdown list to paste to new table in another worksheet CaptainRetired Excel Programming 18 01-04-2018 07:22 PM
Dropdown select worksheet to point data? Use function to select another worksheet eugeneradial Excel 2 04-27-2017 04:53 AM
Dropdown select worksheet to point data? Select added value from dropdown menu, program output Aleksm Excel Programming 1 01-28-2017 05:40 AM
Dropdown select worksheet to point data? select a cluster of point from a range based on x and y values sandcharles Excel 5 02-19-2015 06:15 AM
Dropdown select worksheet to point data? Appending unique data from one worksheet to existing data on another worksheet EdStockton Excel 1 08-06-2014 11:00 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft