Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Very simple function not working
Hi, I have a list of letters and numbers in B2. I am putting in the formula =b2 in the cell next to it and dragging the formula down. The formula looks fine if I go into each cell and has copied correctly i.e =b3, =b4 e.t.c but all the cells show the info from b2?!?!?! if I click the = for a non working cell and then ok it calculates it correctly but I have thousands of them to do. Please help!!! Scott. -- ScoTTyBEEE ------------------------------------------------------------------------ ScoTTyBEEE's Profile: http://www.excelforum.com/member.php...o&userid=28263 View this thread: http://www.excelforum.com/showthread...hreadid=478260 |
#2
|
|||
|
|||
Very simple function not working
ToolsOptionsCalculation, Check Automatic
-- Kind regards, Niek Otten "ScoTTyBEEE" wrote in message ... Hi, I have a list of letters and numbers in B2. I am putting in the formula =b2 in the cell next to it and dragging the formula down. The formula looks fine if I go into each cell and has copied correctly i.e =b3, =b4 e.t.c but all the cells show the info from b2?!?!?! if I click the = for a non working cell and then ok it calculates it correctly but I have thousands of them to do. Please help!!! Scott. -- ScoTTyBEEE ------------------------------------------------------------------------ ScoTTyBEEE's Profile: http://www.excelforum.com/member.php...o&userid=28263 View this thread: http://www.excelforum.com/showthread...hreadid=478260 |
#3
|
|||
|
|||
Very simple function not working
Sounds to me that the Options for Calculation are set to Manual...
Select Tools Select Options Select the Calculation Tab Select the Automatic Radio button Try it out -- Thanks for your help - Joe Mac "ScoTTyBEEE" wrote: Hi, I have a list of letters and numbers in B2. I am putting in the formula =b2 in the cell next to it and dragging the formula down. The formula looks fine if I go into each cell and has copied correctly i.e =b3, =b4 e.t.c but all the cells show the info from b2?!?!?! if I click the = for a non working cell and then ok it calculates it correctly but I have thousands of them to do. Please help!!! Scott. -- ScoTTyBEEE ------------------------------------------------------------------------ ScoTTyBEEE's Profile: http://www.excelforum.com/member.php...o&userid=28263 View this thread: http://www.excelforum.com/showthread...hreadid=478260 |
#4
|
|||
|
|||
Very simple function not working
Please check the setting under ToolsOptionsCalculation -- it should be set to Automatic. Is it? -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=478260 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Simple, Monday morning brain function | Excel Worksheet Functions | |||
Simple, Monday morning brain function | Excel Worksheet Functions | |||
Replace function not working properly in Excel 2000 SP3 | Excel Worksheet Functions |