12 replies
by jshoe85 Accepted solution
by hal 9000 Accepted solution
You where to say what OS's where involved here and what was being used as a server.
But without any of this I'm assuming that you have a small LAN and several people are require to enter data on an Excel Spreadsheet which is entirely the wrong application for this type of work.
Excel is a Desktop Only Application and not suited to the LAN Environment so you really need to dump Excel and go with a Proper Spread sheet Program that can share it's files between different users. In a situation like this every Office Application is useless to you and you need the proper applications. This way several different people can work on the same document at the same time without interfering with each others work.
So ring M$ and buy the products that you need with the correct number of Licenses and then install this onto the server and have the software running from there and allow the end users to launch the applications remotely.
As for the pop ups that you had previously these where most likely killed off by a recent Office Patch so you'll need to wipe every computer in the place including the server and reinstall everything but not apply the most recent Office Patches and you will then be back to a position where you where previously. If M$ allowed this to continue unaffected how do you expect them to sell copies of Office 12/2007 to people/companies who don't need it?
Col
by jshoe85 Accepted solution
by johnson.charles.c Accepted solution
Use a collaborative (i.e. webtop) application that allows views. Google Spreadsheets for one, or a open version of WSS that does check-in/check-out.
There is no easy solution to this without a commitment from your users in time and patience.
by jshoe85 Accepted solution
by locolobo Accepted solution
I googled excel "read only" notify and found your question but no answer yet. My question is this. Did the workbook change from an unshared workbook to a shared one recently? Did something else change?
Our notification is working but I can't find where to set it. I am curious as to the answer myself.
Good luck.
by jshoe85 Accepted solution
by locolobo Accepted solution
Does the "file in use" dialog still work for other workbooks? If it does maybe you can open the one that doesn't work and "save as". That may not work either so (groan) maybe you can copy and past worksheets from the original workbook into a new one.
If the "file in use" dialog doesn't work in other worksheets then it might be a problem with Excel itself. I can't think of an answer to that other than reinstalling Excel.
Googling for Excel "file in use" hasn't returned anything useful so far.
by jshoe85 Accepted solution
by thomas.clymer Accepted solution
Microsoft SharePoint will allow multiple users to access the file at the same time without loosing data.
Also, if you are using Office 2003, there is an option to allow multiple users to edit the file at the same time without loosing any changes.
by jshoe85 Accepted solution
by jshoe85 Accepted solution
This discussion is closed to new replies.
Trending Hardware posts
Sort by Trending