Excel Shared Workbook Problems

  • Thread starter Thread starter Candice
  • Start date Start date
C

Candice

I have an Excel shared workbook on our network. The file
is not a read only file (I have checked), but whenever
someone other than me opens it, it is listed as [read-
only][shared]. Why are they not allowed to make changes
to the file without saving it under a different name?
This is a file that several people need access to, and it
needs to be in one central location. Is there a way to
fix this so that everyone is able to use this?
 
Any chance that the workbook is on a shared drive that the others can only
read--not write?

Any chance that the file is marked readonly at the OS level?
I have an Excel shared workbook on our network. The file
is not a read only file (I have checked), but whenever
someone other than me opens it, it is listed as [read-
only][shared]. Why are they not allowed to make changes
to the file without saving it under a different name?
This is a file that several people need access to, and it
needs to be in one central location. Is there a way to
fix this so that everyone is able to use this?
 
No, everyone can write to the shared drive. We are only
having issues with Excel workbooks. How do I check at
the OS level for the file to be marked read-only?

-----Original Message-----
Any chance that the workbook is on a shared drive that the others can only
read--not write?

Any chance that the file is marked readonly at the OS level?
I have an Excel shared workbook on our network. The file
is not a read only file (I have checked), but whenever
someone other than me opens it, it is listed as [read-
only][shared]. Why are they not allowed to make changes
to the file without saving it under a different name?
This is a file that several people need access to, and it
needs to be in one central location. Is there a way to
fix this so that everyone is able to use this?

--

Dave Peterson
(e-mail address removed)
.
 
Open File
Go to File Properties General and see what is checked in the bottom section

What OS are on the clients and what Network Software? Also what version of
Excel?
What AV is being used on the clients? Server? Is it marked to scan Excel files?

Do you all need to be writing to it at the same time or just have access to it?
Is more than 1 person actually changing the file at the same time?

Make sure that each client machine has files in all temp directories deleted and
also on the server.






: No, everyone can write to the shared drive. We are only
: having issues with Excel workbooks. How do I check at
: the OS level for the file to be marked read-only?
:
:
: >-----Original Message-----
: >Any chance that the workbook is on a shared drive that
: the others can only
: >read--not write?
: >
: >Any chance that the file is marked readonly at the OS
: level?
: >
: >Candice wrote:
: >>
: >> I have an Excel shared workbook on our network. The
: file
: >> is not a read only file (I have checked), but whenever
: >> someone other than me opens it, it is listed as [read-
: >> only][shared]. Why are they not allowed to make
: changes
: >> to the file without saving it under a different name?
: >> This is a file that several people need access to, and
: it
: >> needs to be in one central location. Is there a way to
: >> fix this so that everyone is able to use this?
: >
: >--
: >
: >Dave Peterson
: >[email protected]
: >.
: >
 
We all have Windows XP. Our server is a Linux machine.
We all have Excel 2002. We don't need to be writing to
it at the same time, just need to be able to alone.
 
If you dont need to be writing to the file at the same time, first thing I would
do is take the Sharing off of the file. I have seen Sharing cause a lot of
problems. Only thing this should change is that is if someone is in the file,
others will be able to open it as a read only file.

On your machine - go ahead and clean out all files and folders in
c:\windows\temp and c:\documents & settings\(you)\local\temp (make sure you
have hidden and system files showing
Reboot



: We all have Windows XP. Our server is a Linux machine.
: We all have Excel 2002. We don't need to be writing to
: it at the same time, just need to be able to alone.
:
:
: >-----Original Message-----
: >Open File
: >Go to File Properties General and see what is checked in
: the bottom section
: >
: >What OS are on the clients and what Network Software?
: Also what version of
: >Excel?
: >What AV is being used on the clients? Server? Is it
: marked to scan Excel files?
: >
: >Do you all need to be writing to it at the same time or
: just have access to it?
: >Is more than 1 person actually changing the file at the
: same time?
: >
: >Make sure that each client machine has files in all temp
: directories deleted and
: >also on the server.
: >
: >
: >
: >
: >
: >
: >: >: No, everyone can write to the shared drive. We are
: only
: >: having issues with Excel workbooks. How do I check at
: >: the OS level for the file to be marked read-only?
: >:
: >:
: >: >-----Original Message-----
: >: >Any chance that the workbook is on a shared drive that
: >: the others can only
: >: >read--not write?
: >: >
: >: >Any chance that the file is marked readonly at the OS
: >: level?
: >: >
: >: >Candice wrote:
: >: >>
: >: >> I have an Excel shared workbook on our network. The
: >: file
: >: >> is not a read only file (I have checked), but
: whenever
: >: >> someone other than me opens it, it is listed as
: [read-
: >: >> only][shared]. Why are they not allowed to make
: >: changes
: >: >> to the file without saving it under a different
: name?
: >: >> This is a file that several people need access to,
: and
: >: it
: >: >> needs to be in one central location. Is there a
: way to
: >: >> fix this so that everyone is able to use this?
: >: >
: >: >--
: >: >
: >: >Dave Peterson
: >: >[email protected]
: >: >.
: >: >
: >
: >
: >.
: >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top