Kym-Marie has attended:
No courses
Excel and Files on Network Drive
Hi,
We are working on spreadsheets that are saved on a Network Dive with full permissions. There are two files that we are using and their data is interlinked.
At the moment anyone can view the files but if they try to update the information on one sheet the data doesn't update on the second sheet. The only person who seems to be able to update the data is the person who created the files in the first place.
How can we override this so that anyone can update the informaiton from their own PC?
Thanks!
RE: Excel and Files on Network Drive
Hi Kym-Marie,
Thank you for your question.
Can you please check the following things:
1. Has the file got any form of sheet protection on it?
If you are going to try point 2 I would advise to create copies of each workbook in case you are not happy with the results.
2. Try and share the workbook so multiple people can access it at the same time.
3. Make sure both files are on a public drive that eveyone has access to.
Do you get a message when you try and update the information and if you do what is it?
Regards
Simon
RE: Excel and Files on Network Drive
Hi
The files are on a public networked mapped drive that everyone has full read/write access to. The sheet does not have any restrictions on it.
RE: Excel and Files on Network Drive
Hi Kim-Marie,
Thank you for your reply.
I am going to pass this on to a colleague to see if he has any different ideas.
Regards
Simon
RE: Excel and Files on Network Drive
Hi Kym
In principle the setup you describe should work.
Whilst I can't give you a fix for the problem you are experiencing you may wish to try some troubleshooting to try and pin down what is causing it.
From a different machine make two fresh workbooks and link them. Then edit the source on one of the other network machines to see if the file is updated.
Let me know how you get on.
Kind regards,
Andrew
