Excel (Calculations)

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

Resolved · Low Priority · Version Standard

Michael has attended:
Excel Advanced course
Excel VBA course

by - delegate Michael [7 posts] (2008 Feb 8 Fri, 16:00) Reply

When utilising a large number of formula (30 columns, 62000 rows)is there a way to stop the sheet from calculating until all amendments have been made. At the moment the machine/excel are crashing due to the demands of the formula calculations.

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Excel (Calculations)

by - trainer Pete platinum contributer [864 posts] (2008 Feb 8 Fri, 22:02) Reply

Hi Michael, Thanks for the post, in answer to your question; 62000 rows? 56,536 max, however to stop your computer from calculating every time an entry is made go to Menu command Tool, Options and in the Calculation Tab, Choose the option to Manually calculate, when you have entered all your amendments press the F9 (Function 9) key to calculate.
Hope that helps, best regards Pete

RE: Excel (Calculations)

by - delegate Michael [7 posts] (2008 Feb 13 Wed, 08:25) Reply

Thank you - it has resolved my query. (65,536 rows available in excel)

· Reporting and Analysis with Excel
· How Excel Training Can Improve Your Company's Sales Process
· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Microsoft Excel Training Course

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

Excel tip:

Validating text entries

1. Select the range of cells.
2. From the Data menu, select Validation.
3. Select the Settings tab.
4. From the Allow dropdown list, select Custom.
5. In the Formula box, enter the following formula:
=IsText (A1)
where A1 is the first cell in the range.
6. Click OK.

View all Excel hints and tips

Rate this page: