Email:      Pass:    Pass?
Close Window   
TE
Subscribe for Email Updates!
Excel tips, help, and more!
E-mail:


Advertisements


Free Excel Forum

Multiple Excel Users Can Open The Same File And Edit At The Same .

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

We are running Excel 2002 SP2. We recently moved to a Windows 2000 server
and now we are running into the issue where Multiple users can open the same
excel file and edit it at the same time without getting the file the 2nd time
in Read Only mode.



View Answers     

Similar Excel Video Tutorials

Helpful Excel Macros

Close a Workbook after a Time Limit is Reached
- This macro will automatically close the workbook in which it is located after that workbook has been opened for a certai
Open any Program from Excel
- This free excel macro allows you to open any program on your computer from excel. You can open a media player, file vie
Open a PowerPoint Presentation from Excel
- This free macro for Microsoft Excel allows you to open any PowerPoint presentation from excel. You can change the file
Excel Macro to Save a Specific Worksheet as a New File
- This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a
Automatically Run a Macro at a Certain Time - i.e. Run a Macro at 4:30PM every day
- Automatically run an Excel macro at a certain time. This allows you to not have to worry about running a macro every da

Similar Topics







Hi. I've got a question about a shared Excel file stored on Windows 2000
server. This file is accessed by two different Windows XP end users running
Excel 2002 on their machines. Recently these two different end users have
been accessing the same shared Excel file simultaneously without the usual
file lock or warning that the file is in use. Sometimes they get the
warning, sometimes not. When they don't, they assume they have rights to
save to the file, only to find later on that their changes were not saved.

I'm having both check for updates so that their Microsoft software is current.

Any clues what's going on?



Hello All,

I have an Excel file which I want many users to access at a time. These users are located in different cities and sharing this file on a Sharepoint Server.

I have set up versining options on Sharepoint Server.
I have shared the workbook for multiuser functionability

However, if a user opens this file, other users get a message that the file is locked by a user and hence, either other users can open it as Read-only or wait till they get notifivation of previous user has closed the file.

After browsing various forums, I have arived at a conclusion that multiple user editing simultaniously is not possible on Share point server.

Can any one help me whether is there any other way to achieve this? (other than Sharepoint server)

Is it possible if I upload it on a std. server and share the file by giving direct access to it to all?

Thanks,
Nik


Good morning.

(Is it possible to edit excel file by more Users at once?)
Ussually only the first user who open common excel file can edit and save the file. For other (next) users is the file only 'read only'.
Is there any way to edit and save (use) the file by more users at once?

Thank you for your help.

MiStr.


Hi,
My excel file cannot be accessed and edit by more then one user at one time. If one of the users is editting the excel file, there will pop up a message with " Read Only" when others are trying to access to it. What is the problem with my excel file? Is it something wrong with my VB coding?

Looking for solution and reply...

Thank you.


Hey.. I am trying to figure out how to set up a workbook so that all of the following can occur:

1) The workbook is shared
2) It requires a password to open up as editable, otherwise it will open up as read only.
3) If it opens up as editable, it should require another password to be edited except when editing certain columns. (aka, the workbook should be protected except for certain columns).

So to clarify, if I open the file and do not have the password, the only thing i can do is view the data - I cant edit anything. If I have the password to open the file, all I should be able to edit is certain columns, unless I have the separate password to unprotect a sheet which will give me full control.

Is there a way to get all of these things at the same time? Are there any problems when running shared excel files over a network where 2 users are able to edit the file?

Thanks.


Hello all,

I have a question about the spreadsheet. One of the files I have has 16mb, the file is password protected and contains a lot of formulas. In the past recent weeks, I was able to open it without any issues, but started in the previous week. I was not able to open the file either as read-only or with the password right away. It takes at least may be 10 up to 20 minutes to open. Even opening it as read-only still does take a little while to open it. Does anyone know why? Oh, what I have noticed though, I tried opening the file with Windows XP and it worked. But not with Windows 2000 though. I am using Windows 2000 at work and it's just annoying that when I need to update my spreadsheet. I have to find a desk that has a PC running Windows XP. It's quite not convenient to me at all,and I have no clue!of what could have caused this issue to occur at this time. If anyone can analyze this for me and tell me how to fix this. I would really appreciate it so much.

Thanks.


I have a link to a file on a web page. Looks like this:
file://servername/foldername/filename.xls

I keep seeing people having problems with the macro in this file. There's no sharing of data or even saving of data in the file. The file prompts the user to open as read only or provide a password. It's really just a form that gets filled out and the original is never changed by the users. I'm the only one who knows the password to save changes. I have been changing the file often - that's why I put it on a web site - so people would always have the newest version rather than looking through their email every time they need to use it.

Sometimes the macro just doesn't do everything. Sometimes when people try to open the file Excel tells them it's locked for editing by one of the other users who doesn't know the password to to off read-only mode.

Is there something Excel and/or macros running from a link on a web server that may be causing my problems?


How can I share a file on a network drive where a user can open it ONLY as a read only without going through process of clicking 'read only' on a file that is protected?

Adding an 'extra step' to a simple process like opening an excel file has caused many non-experienced excel users a little frustration both on their end and my end.

I want a file that they can open, and it immediately opens for them as a READ ONLY while when I open it, I can do administrative work on it at the same time, etc.

Thanks!


Hi,

Sorry about the long title, we have a number of spreadsheets that reside on a file server (permissions to these spreadsheets controlled via AD to their folders). Recently we have upgraded to excel 2007 and some users have reported that when one of them is using the spreadsheet, another user can open it and they dont get prompted to open it "read only" / notify etc... They just get straight in and can start editing.

Any ideas why this might be happening?

The spreadsheets in question were created in excel 2000 before the upgrade, but this has only seemed to affect 3 so far.

Thanks.

Owen


Hi Guys,

Have a name.xlm file that was likely created in office 2000. I'm running excel 2007, but when I click on the file I get the error "the file you are trying to open name.XLM is in a different format than specified by the file extension... yada yada... do you want to open the file now?" yes/no/cancel.

I click yes but nothing happens, excel stays blank, doesn't even open a blank worksheet - the program isn't freezing or anything. Removing the error (via regedit as specified by the microsoft tech support) didn't help. I can't edit the XLM file itself as I'm one of only a few running office 2007, it's a common file and most of the users here have office 2000. When I had office 2000 it was no problem to open.

Any ideas? thanks in advance.


Hi,

I am working on a project in VB6.0 and SQL Server. We use MS Excel for our reports. We also

use server side COM+ components.

We have a situation where we are not able to open some of the reports in 'protected' mode

(i.e, to prevent the users from making changes to the excel report). When we try to open

these in protected mode, the application is crashing, giving a Dr. Watson error.

When we change the VB code to open the excel reports in 'Unprotected' mode, the applcation

works alright. But in this case, the users would be able to change the reports as they like.

Why am I not able to open these excel reports in protected mode from my VB6.0 exe?

Is there a way, where we can prevent the users from making changes to the excel report, even

if we open it in 'unprotected' mode?

We tried using the 'Read Only Recommended' option but that allows the users to make changes

and save changes as some other file name (although the users are prevented from making

changes to the same file) and this cannot be allowed in our application.

Any help in this regard is greatly appreciated.

Thanks in advance
ourspt


At work we just started using an Excel document that requires us to open the document and then edit it. The problem is that their are about 6 different users and only one person can edit the document at a time. The others are in a "read only" mode while the one person edits. My Boss (who created the document) states we will just have to take turns-it is very inconvenient as each of us are in and out of the document all day editing information. Is there a fix so that multiple users can edit the document simultaneously?-Thanks


I have an excel 2007 file sitting in a shared network folder. I only want one user to be able to make changes at a time (any other users would get a read-only). For some reason it currently does not do this, and I have multiple users with the same doc open. I'm concerned that changes will get over-written when 2 people are saving their changes. Can anyone help me with the settings for this.


I have a file that will be saved to a common shared drive where a slew of other files are saved. Some of the staff who have access to the share will only need read access to this particular file and creating separate folders with varying levels of read-write access will be too difficult. Is there a way for me to set a workbook to read-only mode while it's being opened, from say the Workbook Open event? I want to include a hidden sheet that contains a list of users who should have edit access and have it checked to determine whether the user should have read or edit rights when the file is opened.

The file is currently saved in a restricted share and has code in the open/close events to confirm the users ID or prompt for a password and hide certain sheets from view if they ar enot authorized.


We have several Excel spreadsheets that were created and protected in Excel 97 and 2000. Many of the wks are forms used by personnel for submitting expense reports, planning travel, etc. Recently we migrated all of our users to Office XP (Excel 2002).

Now when a user opens one of the spreadsheets created and protected in Excel 97/2000 in Excel 2002, enters data and then saves and closes it, when they re-open it all of the previously selected cells are un-selectable by the user.

If the user just opens one of the wks and does not make any changes and then saves it, when they reopen it the cells are not user select locked. The cells are only user select locking after data is entered and the file is saved.

Once the cells are user select locked, if the user takes the file back to a system still running office 2000 and opens it, the user can select and edit the cells contents.

Also if we open the cell select locked file in 2002 and save it as a Excel 95 file and then reopen it in 2002, the users is then once again able to enter data.

We fixed some of the wks by un-protecting them and then resetting the protections. However, this is not an option for all of the files as we do not control them.

We understand that Excel 2002 provides the developer with much more granularity in the protection options than previous versions. However, one would think that as cell user select locking was not an option in the earlier versions, Excel 2002 would not be enable this by default when working with a protected XLS file created in a previous version.

Does any by have an explanation and hopefully a solution for this does not require us to rework all of the files?

Thanks


Hello,

I posted this same question in the Access forum, but thought it may be useful to post it here as well.

My issue is ... I have an Access database table linked to an Excel file and I am wondering if it is possible for the Access database to be opened by multiple users while each instance of the open database is linked to the same excel file. Currently I can only have the database open in one instance if I try to open it again I receive a Microsoft Engine error stating it cannot access the excel file because it has already be opened in executable state. I tried setting the Excel file's open properties to read only, but it seem the Access database always opens Excel file's in executable mode? Not sure if it is somehow possible to get Access to open the linked Excel file in read only mode?

Any suggestions would be amazing...

Thanks in advance.


Hello.

I need some help.

I have an Excel File in my flashdrive that I've been accessing for the longest time, I regularly open it and edit it. It requires a password in order to be opened.

I tried to open it earlier, it asked me for the passowrd. I entered it and the following message appeared:

"[Filename.xls] cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding"

In the same flashdrive, I have other excel files that I can open and edit without any problems.

How do I solve this?

thanks very much.


Prevent multiple users accessing the same file at one time regardless of read only or not.

I have an excel file in a LAN drive that is shared by a couple departments. It's a master database for a project that we all are working on.

I.T. has restricted access to this folder to a handful of people who are intimate with this project. all of us who have access have read/write access.

This project has live for a few months now, so there is no need for more than one person to be in the file at a time. So, now I want to restrict access when some one is in the file.

Currently, if someone is in a file that you want to access, it gives you three options:

-Open Read only
-Notify
-Cancel

I want to disable this. Is there a way?


Hello,

I created an add-in (.xlam) in Excel 2007 which has a number of user-defined functions. The add-in was deployed to a shared network folder as read-only so: (a) it could be referenced by multiple users at the same time and (b) we could easily deploy changes.
The individual functions within the add-in have worked properly and have thrown no errors.
The problem we are encountering is the functions often are proceeded by the folder where the add-in is located. So, users enter =GetFinancialValue(A1) -- where GetFinancialValue is a function we created. It initially works fine. Then, when the user closes and reopens the spreadsheet -- or sends it to someone else, the function is proceeded by: '\\servername.net\files\Software\ExcelAddIn\CompAddin.xlam'!GetFinancialValue(a1). The folder name is correct and may be referenced by all users. Why do this folder name occur? This causes the udf to not run and return #VALUE!.
We can resolve this by going into 'Data' --> 'Edit Links' and clicking 'Open Source' -- then everything calcs properly and the folder name is dropped from the udfs. But, the next time we open the file the same issue occurs again. Don't want users to have to do this every time they open a spreadsheet. When we click on 'Check Status' from the same 'Edit Links' dialog it displays 'Source is Open'


Thanks so much for any help you can offer. This is driving us nuts.

Thanks,
Dan


Hello.

I need some help.

I have an Excel File in my flashdrive that I've been accessing for the longest time, I regularly open it and edit it. It requires a password in order to be opened.

I tried to open it earlier, it asked me for the passowrd. I entered it and the following message appeared:

"[Filename.xls] cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding"

In the same flashdrive, I have other excel files that I can open and edit without any problems.

How do I solve this?

thanks very much.


Hi,

I have a workbook located in a network folder which is supposed to be updated only by two of us and other users are supposed to view the same.

The problem is that other users open the file but leave it open in their computer and therefore when I open it for edit or update, it says that file is in use by 'so and so' and unable to edit and save it.

I need a routine that should close the file automatically if the file is kept open for more than 5 minutes except for two users (eg:ABC and PQR).

Your help is highly appreciated.

Thanks


I have some programs that will call up Excel and open a file. The problem is that if I already have Excel running, the new file will be opened in a new Excel and so tabs cannot be copied or moved from one file to another. It's like having two different Excel programs running. If I had only one Excel program running and multiple files opened, I could copy tabs from one file to another.

Instead of starting Excel again, is there a way to limit the other program so that it would use the Excel program already running and just open the new file?


I have a series of Databases connected together and multiple people can be logging data throughout the day.

I then harvest the data by using excel and a data connection to create a pivot table to pull the data into excel.

The problem is when anyone has the data bases open I cannot query the data base with excel and the other way around, when I have the excel file open, no one can get into the data base.

Since these data bases are connected by queries, they don't query if someone has the other data base open or I have my excel sheet connected to it.

These are all on a server share windows 2003 server and I used the Server Manager to create the share.

What do I need to do here? Is this an setting in Access or is it the share. I am the admin of the data base - do I need to put it into a certain mode before making it available to all users?

Its a race, whoever gets it first has access to it, you can't even open the data base to veiw the data if someone has it open, it returns an error that its locked or can't read the table because its in use or something like that.

The exact error is
You cannot open a db that is already open by User "Admin" on machine xyz, try again when the DB is avialble.

Thanks!


Scenario: Multiple users with different network drive mappings using the same file. Said file needs to be linked to another file on the network to pull data with a VLOOKUP function.

Problem: Excel changes the link from Universal Naming Convention (UNC) to a drive path when other users open it. I've tried to edit the links by browsing through My Network Places and this works until another user opens the file and then it changes the link again. I've read through the article " Description of link management and storage in Excel " but I'm still stuck. I have macros in the same file that use UNC without a problem.

Question: Can I somehow keep the UNC path in the formula despite various users opening the file?

Thanks.


Hi all, did a search, found this
http://www.mrexcel.com/forum/showthr...ght=force+read
which got me half way there, but looking for help on the last bit.

I've got a file which I would like to set up so that certain specified users can only open it as read only, while other specified users can open a read/write version.

I don't really mind which way round this works - either I would specify the read only users, and all others would be read/write by default, OR I'd be happy to specify the users who could read/write, and all others would be read only by default.

I adapted the code in that other thread to this,
Code:

If Not ActiveWorkbook.ReadOnly Then 
ActiveWorkbook.ChangeFileAccess Mode:=xlReadOnly


which works. I've incorporated it into the Auto Open routine, and it correctly makes the file read only.

What I want to do is add something that says effectively...

If user = John Smith, Jane Brown
open the file as read only
else

and I need help with the bit in bold.

Any ideas ?

Thanks in advance...