The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel and Files on Network Drive

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Excel and Files on Network Drive

Resolved · Medium Priority · Version 2007

ReplyTue 12 Jan 2010, 10:17Delegate Kym-Marie said...

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!

For upcoming training course dates see: Pricing & availability

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

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.

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

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

Excel articles

· How to Create Better Excel Spreadsheets: Part Four
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Excel: Save Time With AutoFill
· How To Create An Excel Formula Using Data From Several Worksheets
· Why Should I Learn Visual Basic in Excel?

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

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips

How do you colour a chart at one go.