Excel and Files on Network Drive

The UK's most regular instructor-led training courses.
Training information: excel microsoft training · Excel training london · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Medium Priority · Version 2007

3 posts

ReplyTue 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!

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Fri 19 Mar 2010	Bloomsbury	1		£240	£245
2003	Wed 24 Mar 2010	Limehouse	7		£212	£217
2007	Fri 26 Mar 2010	Rochester (Hoo)	0	FULL
2007	Mon 29 Mar 2010	Bloomsbury	2		£235	£240
2003	Wed 31 Mar 2010	Southwark	7		£219	£224
2007	Tue 6 Apr 2010	Limehouse	5		£235	£240
Full Schedule: See all 70 Excel Advanced course dates. Bookings currently available until 22nd December 2010.

648 posts

ReplyWed 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

3 posts

ReplyWed 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.

648 posts

ReplyThu 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

1,056 posts

ReplyTue 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

· Microsoft Excel as a Reporting Tool
· Utilise the web's information banks with Microsoft Excel
· Microsoft Excel Training: Not Just for Newbies Anymore
· Special Characters in Excel
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business

Please browse our web site to find out more about
excel microsoft training and other Microsoft training courses.

Excel tip:

Deleting a range of cells using the autofill handle

Firstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted.

View all Excel hints and tips