Formulas hidden

Resolved · Medium Priority · Version 2013

Mon 10 Feb 2014, 16:42 Delegate Eulalia said...

Eulalia has attended:
Excel Advanced course

Formulas hidden

How to solve the problem, working with macros, when some formulas are hidden and is slowing down the process of calculating, copying and working with the rest of the spread sheet.

Mon 10 Feb 2014, 17:12 Trainer Gary said...

RE: formulas hidden

Hi Eulalia

Thanks for getting in touch. There are two options here, depending on if you are confident editing the VBA code.

The manual method is before running the macro, to disable calculation then reactivate it once the macro has finished. You can disable calculation from the Formulas menu, selecting Calculation Options and then Manual.

If you are confident editing a macro (View > Macros > highlight your macro and click edit). You can add the line

Application.Calculation = xlCalculateManual

to the top, then

Application.Calculation = xlCalculationAutomatic

to the bottom.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 17 Feb 2014: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.

View all Excel hints and tips