Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel.training.course.london - accessing different work books

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel.training.course.london - Accessing different work books/ locked files

excel.training.course.london - Accessing different work books/ locked files

ResolvedVersion Standard

Samantha has attended:
Excel Intermediate course

Accessing different work books/ locked files

How do you open and use a document that has been locked by another user so that you can change data because you are working fom the same Excel spreadsheet?

RE: Accessing different work books/ locked files

Hiya Samantha

Hope you are ok today

with regards to your troubles this depends on the way this is locked as there are two ways, 1 if you try to open the file and a message comes up tell you its locked by Mr Smith, and the 2nd one is when you try to open the file and it asks you for a password

If you get the first error saying it this file is in use then either get them to close it or you will have to try again later

If you get a password option then unless you get the person password with their permission then also unfortunatly you cant open and use that file

You may be aware that excel files can be shared so that more than one person can use it at the same time

Contact you IT department on how to do this that may help

hope this is useful

Mark East

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.



View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.