Solved

How do I allow all users to open an Excel Spreadsheet without being read-only?

Posted on 2011-03-04
8
305 Views
Last Modified: 2012-05-11
I've created a spreadsheet that contains a couple macros and a pivot table.  I want about 4 different users to be able to open, edit, and save the workbook.  They will not be working on it at the same time.  The workbook will be on a network drive.  Right now only the creator and one other user can access the workbook without it being read-only.  All the users are Administrators also.  Any ideas?
0
Comment
Question by:bretthonn13
  • 5
  • 2
8 Comments
 
LVL 45

Expert Comment

by:patrickab
Comment Utility
>How do I allow all users to open an Excel Spreadsheet without being read-only?

You can't unless the workbook is 'shared' and that can lead to a corrupted file.
0
 

Author Comment

by:bretthonn13
Comment Utility
What part of the spreadsheet does not allow others to change and edit it?  I've got many spreadsheets that are viewed and edited by multiple users, but this is the first with macros and a pivot table.  I've never 'shared' a workbook before.  Always just thrown it out on network drive and 2 - 3 different users could have at it.
0
 
LVL 45

Expert Comment

by:patrickab
Comment Utility
>Always just thrown it out on network drive and 2 - 3 different users could have at it.

Keep the files single user and you will avoid file corruption.
0
 
LVL 10

Expert Comment

by:Fayaz
Comment Utility
When the file is open by one user and a second user opens the file, it will notify as read-only.  But you can choose to notify and excel will notify when the other user closes the file and is no longer in read-only mode.  i.e. when the file is open by one user and other users open the same file at the same time...

I sugest looking at Excel sharing option:
http://office.microsoft.com/en-us/excel-help/administration-of-shared-workbooks-HA001013057.aspx
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Comment

by:bretthonn13
Comment Utility
Fayaz - I understand the read-only when it's opened by a user, but in this case the file has been closed by me and I am trying to open and use it on a different pc sitting right next to me.  I'm doing this so I can gaurantee that no one else is in it.  I'll take a look at your link though and see if it's got any ideas.
0
 

Author Comment

by:bretthonn13
Comment Utility
Another thing I've just found out is we have a certain spreadsheet that is accessed by about 3 different users (all at different times).  They can all make changes, save, and do whatever they need and it has never been read-only for anyone.  Is there something that needs to be done before it is saved for the first time?  There were no sharing options setup or protections enabled.  The only thing it has is a password to open the file.  The person that created it feels they didn't do anything special, but I cannot get it to fail.  No matter what computer I open it on or what user opens it the file is NEVER read-only.  Very strange.
0
 

Accepted Solution

by:
bretthonn13 earned 0 total points
Comment Utility
It was my network folder permissions.  All the other files that were fine were on a different shared drive with the appropriate permissions.  Once I established the correct permissions everything was fine.
0
 

Author Closing Comment

by:bretthonn13
Comment Utility
I solved my own problem by continuing to search other sources.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now