×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Open in read only mode

Open in read only mode

Open in read only mode

(OP)
Is there a way to open an file in read only mode ?
I don't intent to make changes while I have it open and at the same time have the file available for others who may want to open in writable mode.

In our office we use a spread sheet parts log file and more than 20 guys use it. If I am using it to just reference or read or search some data in the file, its not Avilable for others to write into it.

Any solution ?

Thx

RE: Open in read only mode

Quote (Excel Help -- Open Read Only)

When you open a file as read-only, you are looking at the original file, but you cannot save changes to it.
1.Click the Microsoft Office Button, and then click Open.

Keyboard shortcut To display the Open dialog box, press CTRL+O.
2.In the Look in list or Navigation pane, click the folder, drive, removable media (such as flash drive, CD, or DVD), or Internet location that contains the file that you want to open.
3.Click the file that you want to open as read-only.
4.Click the arrow next to the Open button, and then click Open Read-Only.

Give the Excel help a try. It's pretty good.

Best to you,

Goober Dave

Haven't see the forum policies? Do so now: Forum Policies

RE: Open in read only mode

It's in the help files:

Use a shared workbook to collaborate
Show All
Hide All
You can create a shared workbook (shared workbook: A workbook set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users.) and place it on a network location where several people can edit the contents simultaneously. For example, if the people in your work group each handle several projects and need to know the status of each other's projects, the group can use a shared workbook to track the status of the projects. All persons involved can then enter the information for their projects in the same workbook.

As the owner of the shared workbook, you can manage it by removing users from the shared workbook and resolving conflicting changes. When all changes have been incorporated, you can stop sharing the workbook.

TTFN
FAQ731-376: Eng-Tips.com Forum Policies

RE: Open in read only mode

(OP)
Guys,

You are awesome! Thanks

C1

RE: Open in read only mode

You can also leave the file available for other by using the "New" function in Windows Explorer. Instead of double clicking to open the file, right click, then select New. I make a habit of opening most files this way so that I don't accidently over write the original if I save the document when closing it.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources