h90 Posted July 31, 2013 Share Posted July 31, 2013 We have our stock in a large excel file, as we didn't found any suitable software, yet. The problem is 95 % of the time we open it on the network to look at something. 5 % someone want to make changes. If I make it read-only it can not be changed. If it can be read/write only the first one who opens it can save it. Perfect would be if we could right-click it and have the option to open as "read-only" Or any other idea how to handle it. There are approx. 10 people and computer who may use it and all need to run around in the office/workshop, so you can't simply ask everyone. I think there is surely a very simple solution...I just don't see it. Link to comment Share on other sites More sharing options...
Guest Posted July 31, 2013 Share Posted July 31, 2013 Any possibilities to move the file to google docs? Then you could could do the changes simultaneously. Link to comment Share on other sites More sharing options...
h90 Posted July 31, 2013 Author Share Posted July 31, 2013 Any possibilities to move the file to google docs? Then you could could do the changes simultaneously. No, because internet is sometimes slow here (there are minutes where it doesn't work at all, even webradio doesn't work well) and some files are large (13 MB). Second I would not let company documents outside. I guess there are some simple solutions just I think too much in one way.... Link to comment Share on other sites More sharing options...
thaimite Posted July 31, 2013 Share Posted July 31, 2013 I think the answer is to use a batch file to open the spreadsheet. See this blog You could have two batchs files on the desktop. One to open Excel as read only and the other as normal, or if you want to spend a dfew minutes you could make the batch file ask you if you want to open as read only or as read/write with the default as read only. Of course trying to open the file as read/write will still fail if it is already open as read/write elsewhere. There is more infomation here Link to comment Share on other sites More sharing options...
bangkockney Posted July 31, 2013 Share Posted July 31, 2013 What version of Excel? Link to comment Share on other sites More sharing options...
h90 Posted July 31, 2013 Author Share Posted July 31, 2013 What version of Excel? 2010 version Link to comment Share on other sites More sharing options...
h90 Posted July 31, 2013 Author Share Posted July 31, 2013 I think the answer is to use a batch file to open the spreadsheet. See this blog You could have two batchs files on the desktop. One to open Excel as read only and the other as normal, or if you want to spend a dfew minutes you could make the batch file ask you if you want to open as read only or as read/write with the default as read only. Of course trying to open the file as read/write will still fail if it is already open as read/write elsewhere. There is more infomation here great thanks! Link to comment Share on other sites More sharing options...
bangkockney Posted July 31, 2013 Share Posted July 31, 2013 What version of Excel? 2010 version Just use the Share functionality then. Does exactly what you want (and more?). Link to comment Share on other sites More sharing options...
NeverSure Posted July 31, 2013 Share Posted July 31, 2013 What version of Excel? 2010 version Just use the Share functionality then. Does exactly what you want (and more?). +1. If it's a network and the file is on one computer, it needs to be shared with everyone. Right-click on the folder it's in, choose properties, then sharing, then advanced sharing. Now allow everyone full control. Link to comment Share on other sites More sharing options...
frankold Posted July 31, 2013 Share Posted July 31, 2013 A local install of some collaboration software would manage it and any other similar document and also likely fix other issues you have in regards to data sharing etc. There is a community edition of feng office that would fit the bill. Link to comment Share on other sites More sharing options...
KittenKong Posted August 1, 2013 Share Posted August 1, 2013 The Excel 2010 share function is a bit of a kludge at best, especially if users forget to save their changes promptly and before starting work. I would be inclined to use LibreOffice Base and create a shared MySQL database using EasyPHP or WAMP on one networked PC. This technique is specifically designed to support multiple simultaneous users. And being a database it can be extended to perform just about every related function any business could want: stock control, billing, client list etc etc. Link to comment Share on other sites More sharing options...
h90 Posted August 1, 2013 Author Share Posted August 1, 2013 The Excel 2010 share function is a bit of a kludge at best, especially if users forget to save their changes promptly and before starting work. I would be inclined to use LibreOffice Base and create a shared MySQL database using EasyPHP or WAMP on one networked PC. This technique is specifically designed to support multiple simultaneous users. And being a database it can be extended to perform just about every related function any business could want: stock control, billing, client list etc etc. Thanks, is it easy to use for a beginner? Link to comment Share on other sites More sharing options...
KittenKong Posted August 1, 2013 Share Posted August 1, 2013 Thanks, is it easy to use for a beginner? Easy enough once it is set up. But the setup is for someone who knows what he is doing. Hugely flexible and powerful once set up though. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now