Problem with formula in MS Excel

[Azilan]

Good Day

Operating System: Windows XP
Office Package: Office 2003

Problem is as follows:

User copies information from MS Access to MS Excel. He created a basic formula whereby column B has a number in each cell. Column C has the percentage 100 % in each cell and column D is supposed to indicated column B x column C in a percentage format.

The total in cell D1 works perfectly, but as a soon as an auto complete is done downwards all the cells below cell D1 indicates the same information and doesn't automatically adjust.

The format of the cells in column B is General and the format for the cells in column C and D is percentage.

Please advice what first line support can be done to rectify this problem.

Thanks.

 

[GlennUK]

It sounds like you have Calculation set to Manual. Do menu command Tools/Options and see what the Calculation setting is.

 

[Andrew Poulsom]

Is Calculation set to manual (Tools|Options|Calculation tab)? If so you will have to press F9 to update the formulas.