not sure if my last post went through

[Danielle]

Sorry, when I clicked post it said not enough memory, so just to be
safe I am posting again....

I am having trouble creating an excel 2004 workbook and saving it to
the shared. When I attempt to do this from my computer it opens on the
other computers as a read only. My computer is the only one doing
this. There are 4 other computers that are able to create workbooks,
save them to the shared, then access them from other computers with out
a read-only error. I've checked my permissions and so forth and it
does not have any locks or read-only set. Any help would be
appreciated, perhaps I am overlooking something?

 

[Danielle]

I just tried this after looking through excel. Tools-share workbook,
then set it so changes can be saved. Did I do good? Now the workbook
can be opened on another machine, but it has (shared) next to the file
name. Should I have all the othere excels set up for shared workbooks?
Thanks

 

[CyberTaz]

Yes, you did fine. [Shared] appears next to the file name as a reminder
that it is a shared file regardless of how few users have it open at
one time. Perfectly normal |:>)

 

[Danielle]

i have been playing around with the options because we make constant
changes and don't want more than one person having it open at the same
time working on it. I noticed in the "Help" section it says that when
you have it set up as a shared workbook it has restrictions such as not
being able to change formulas and not being able to add or delete
cells. I tried doing so and I did not have any restriction problems.
Do you think that's right? I just hope later on down the road it
doesn't start to restrict changes...

 

[CyberTaz]

I'm not an expert on the feature, so if one of the MVP's tells you
otherwise, go with what they say.

If you *do not* want more than one person using the file at a time, then you
should turn off the Sharing feature. Simply store the file in a "shared"
network folder where the users have access to it. If the file is not
designated within Excel as Shared, everyone will have to wait their turn to
make any changes to it. Others should be able to open the file as Read Only
while that one user has the file open for editing. In that case, the
following is irrelevant.

The points about editing primarily pertain to 1) while the file is open by
more than 1 person, & 2) by someone other than the "owner" of the file.

When you open the workbook while nobody else has it open, you can make any
changes you want and save those changes. technically, though, there is a
safeguard that should be followed which is to open the file Exclusively.
This not only notifies anyone else currently using the file to Save & Close,
but once you Open Exclusive, nobody can get into the file until *you* save
& close.

HTH |:>)

 

[anthony forlini]

So it was going fine and dandy for a few days and now we are running into
problems again. We have been saving the workbook as normal and putting it
in the shared folder. It is driving me insane though because sometimes
others can open it, work, and save in it just time, and other times the
workbooks come out as read only. When we have the read only problem I
resort to making it a shared workbook,that works for a while and then we get
the same problem of everyone only being able to open it as read only. What
the heck is going on? We have the permissions untouched and the settings
every time we open excel are the same as far as I can tell... ???

 

[Bob Greenblatt]

If you want to share the workbook, that is, have more than one user open and
modify the workbook at the same time, do this:
1) make sure everyone has closed the workbook.
2) make everyone QUIT Excel.
3) have one person open the workbook. Under the Tools-share workbook menu,
make sure that allow changes by more than one user is UNCHECKED.
4) Save and CLOSE the workbook
5) Open the workbook. This time on the Share workbook dialog, CHECK the
allow changes by more than one user.

Now everyone should be able to open the workbook.

Note: If the workbook is on a windows server, or shared windows volume, make
sure that real time virus scanning on the server and user machines is turned
OFF.

Look at HELP for more information on sharing workbook. Periodically check
who's using the workbook by viewing the information in the editing tab of
the share workbook dialog. If this list does not match who is really using
the workbook, the file is being corrupted somewhere. Repeat steps 1-5 above
to fix this.

 

[anthony forlini]

I've already followed the steps in help for sharing workbooks. We do NOT
want more than one person in the file at the same time reading and writing.
We DO however want everyone to have access to write, just not at the same
time. When I looked into the file info, I noticed that it says the
following under ownership & permissions details:

Owner: nobody
Access Read & write
Group: Nobody
Access: Read Only
Others: Read Only

Should the owner and group name be changed? I change the access and others
to read & write but is this something I have to do every single time I
create a new workbook? Is there a way to set it to always allow for read &
write for everyone? I'm not sure everyone in our office will remember to
always check the permissions right after they save. Thanks

P.S. We do not use windows