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.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Welcome to the board.

Use Edit --> replace to replace all occurences of = with =
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,520
Messages
6,114,101
Members
448,548
Latest member
harryls

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
Back
Top