Urgent Excel help please!

superscaper

1. Click the Microsoft Office Button, click Excel Options, and then click the Formulas category.

1. Do one of the following:
2. To recalculate all dependent formulas every time you make a change to a value, formula, or name, in the Calculation options section, under Workbook Calculation, click Automatic. This is the default calculation setting. Tip Alternatively, on the Formulas tab, in the Calculation group, click Calculation Options, and then click Automatic.

• To recalculate all dependent formulas—except data tables—every time you make a change to a value, formula, or name, in the Calculation options section, under Workbook Calculation, click Automatic except for data tables. Tip Alternatively, on the Formulas tab, in the Calculation group, click Calculation Options, and then click Automatic Except for Data Tables.
• To turn off automatic recalculation and recalculate open workbooks only when you explicitly do so (by clicking Calculate Now under Calculation Options in the Calculation group on the Formulas tab), in the Calculation options section, under Workbook Calculation, click Manual. Note When you click Manual, Excel automatically selects the Recalculate workbook before saving check box. If saving a workbook takes a long time, clearing Recalculate workbook before saving may improve the save time.
  Tip Alternatively, on the Formulas tab, in the Calculation group, click Calculation Options, and then click Manual.
• To manually recalculate all open worksheets, including data tables, and update all open chart sheets, on the Formulas tab, in the Calculation group, click the Calculate Now button.
• To manually recalculate the active worksheet and any charts and chart sheets linked to this worksheet, on the Formulas tab, in the Calculation group, click the Calculate Sheet button.

Lifeisbutadream

superscaper wrote: »

I assume you mean you're using Excel 2007 (makes no difference what operating system you're using, e.g. I use Excel 2007 on XP and others may be using Excel 2003 on Vista).

Yes that then..:o

Financial_Novice_2

Lifeisbutadream wrote: »

I am using Windows Vista - so no 'tools' then 'options'??

In Excel 2007, click on Formulas, at the extreme right hand side you will see and icon for Calculation options. Click on the down arrow and sect Automatic.

Lifeisbutadream

superscaper wrote: »

1. Click the Microsoft Office Button, click Excel Options, and then click the Formulas category.

1. Do one of the following:
2. To recalculate all dependent formulas every time you make a change to a value, formula, or name, in the Calculation options section, under Workbook Calculation, click Automatic. This is the default calculation setting. Tip Alternatively, on the Formulas tab, in the Calculation group, click Calculation Options, and then click Automatic.

• To recalculate all dependent formulas—except data tables—every time you make a change to a value, formula, or name, in the Calculation options section, under Workbook Calculation, click Automatic except for data tables. Tip Alternatively, on the Formulas tab, in the Calculation group, click Calculation Options, and then click Automatic Except for Data Tables.
• To turn off automatic recalculation and recalculate open workbooks only when you explicitly do so (by clicking Calculate Now under Calculation Options in the Calculation group on the Formulas tab), in the Calculation options section, under Workbook Calculation, click Manual. Note When you click Manual, Excel automatically selects the Recalculate workbook before saving check box. If saving a workbook takes a long time, clearing Recalculate workbook before saving may improve the save time.
  Tip Alternatively, on the Formulas tab, in the Calculation group, click Calculation Options, and then click Manual.
• To manually recalculate all open worksheets, including data tables, and update all open chart sheets, on the Formulas tab, in the Calculation group, click the Calculate Now button.
• To manually recalculate the active worksheet and any charts and chart sheets linked to this worksheet, on the Formulas tab, in the Calculation group, click the Calculate Sheet button.

Thank you - I think this may be whjere the problem lies. I have done exactly as you said, it was on 'Manual' - I changed it to automatic, but then every time I come out of the Excel Options page, it still doesnt work - when I go back in, it is back to manual again.

Lifeisbutadream

When I look on 'formula' then on far right, it is showing as automatic..

Now I am really confused!

Lifeisbutadream

And now it is working again..

Am I going mad or something??

Lakeuk

I'd recommend using the 'Auditing' tool to help in locating an formula syntax issues

Lifeisbutadream

Lakeuk wrote: »

I'd recommend using the 'Auditing' tool to help in locating an formula syntax issues

What is this please?

Lakeuk

Lifeisbutadream wrote: »

What is this please?

http://blogs.adatis.co.uk/blogs/sachatomey/archive/2008/02/13/excel-formula-auditing.aspx