excel vba courses london - Opening an excel document as read only

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

Resolved · Low Priority · Version Standard

Opening an excel document as read only

Anthony has attended:
Excel Advanced course

by - delegate Anthony [5 posts] (2007 Aug 10 Fri, 11:53) Reply

When right clicking on an excel document from the open window the option to open a file as read only is sometimes present. If not how can a file be opened as read only so other users can open the file after you as the main user?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue	Bloomsbury	0	FULL
2003	2008 Nov 27 Thu	Southwark	3	book now	£210	£215
2007	2008 Nov 28 Fri	Bloomsbury	0	FULL
2003	2008 Dec 2 Tue	Bloomsbury	4	book now	£207	£215
2003	2008 Dec 4 Thu	Bayswater	6	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	5	book now	£212	£224
Full Schedule: See all 113 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Opening an excel document as read only

by - trainer Alan silver contributer [73 posts] (2007 Aug 10 Fri, 13:37) Reply

Hi Anthony

When you use the File Open dialog there is a drop down arrow next to the OPEN button. Click the arrow and choose the read only option.

Cheers!

Alan

· Microsoft Excel Training - Numerical excellence for all
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Microsoft Excel Features and Functions for Accountants
· Advanced level training: Microsoft Excel and the Web
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips

Excel tip:

Cycling through Absoulte cell references

If you are working with formulas in excel and need to convert your formula to an absolute formula, instead on manually adding in the $dollar signs you can highlight the specific part of your formula and press the F4 key.

You can cycle through all the absolute options by pressing the button (up to four times)

View all Excel hints and tips