Error using excel formulas

b_bailey

New Member
Joined
Aug 29, 2007
Messages
1
My formulas are not calculating at all on my spread sheets. In the past I was able to create a formula in one cell then click and drag the formula down the column and it would automatically calculate the formulas correctly. In the past week it has not been working. When I try to click and drag the formula down the column it copies the correct formula, but it does not calculate correctly. It has the correct formula in the formula bar but it does not calculate. The only option I have found that works is to select the cell, hit F2, and hit enter. This is not occuring on my spread sheets only, I have talked to many co-workers and they are having the same problem.
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,994
Welcome to the board.

Use Edit --> replace to replace all occurences of = with =
 

goldfish

Well-known Member
Joined
Aug 23, 2005
Messages
712
Welcome!

You probably have calculation set to manual instead of automatic. Hit F9 to update the cells when it is manual mode. To switch out of manual mode go to
Tools -> Options -> Calculations -> Automatic

HTH,
~Gold Fish
 

Watch MrExcel Video

Forum statistics

Threads
1,122,230
Messages
5,594,949
Members
413,953
Latest member
Arthur1471

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top