Staffer at work with problem...
Have Excel file open with simple multiplication formula in it. Wehn I enter
number in cell, the adjacent cell that has the formula in it and depends on the cell where number is entered will not update. Checking and changing the format of the formula didn't change the issue. Assistance Needed. Thanks, MCDST |
Staffer at work with problem...
Make sure calculation is set to automatic.
<Tools <Options <Calculation tab< And make sure Automatic *is checked*. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "MCDST070-271" wrote in message ... Have Excel file open with simple multiplication formula in it. Wehn I enter number in cell, the adjacent cell that has the formula in it and depends on the cell where number is entered will not update. Checking and changing the format of the formula didn't change the issue. Assistance Needed. Thanks, MCDST |
Staffer at work with problem...
RD -
Thanks, solved the problem. Much appreciated. You work for Microsft or just an excel guru? Thanks again, MCDST "MCDST070-271" wrote: Have Excel file open with simple multiplication formula in it. Wehn I enter number in cell, the adjacent cell that has the formula in it and depends on the cell where number is entered will not update. Checking and changing the format of the formula didn't change the issue. Assistance Needed. Thanks, MCDST |
Staffer at work with problem...
Neither one!
I don't believe *anyone* here works for Redmond. And I dye for a living.<g Literally ... dye textiles. -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "MCDST070-271" wrote in message ... RD - Thanks, solved the problem. Much appreciated. You work for Microsft or just an excel guru? Thanks again, MCDST "MCDST070-271" wrote: Have Excel file open with simple multiplication formula in it. Wehn I enter number in cell, the adjacent cell that has the formula in it and depends on the cell where number is entered will not update. Checking and changing the format of the formula didn't change the issue. Assistance Needed. Thanks, MCDST |
All times are GMT +1. The time now is 08:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com