98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel and Files on Network Drive
Excel and Files on Network Drive
Resolved · Medium Priority · Version 2007
Tue 12 Jan 2010, 10:17Delegate Kym-Marie said...
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!
Wed 13 Jan 2010, 11:27Trainer Simon said...
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
Wed 13 Jan 2010, 11:42Delegate Kym-Marie said...
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.
Thu 14 Jan 2010, 16:07Trainer Simon said...
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
Tue 19 Jan 2010, 13:24Trainer Andrew said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Quickly create a list of numbersThe fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next. |
