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
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
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
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
You are awesome! Thanks
C1
RE: Open in read only mode