I'm trying to put two formulas in one cell through a pull down tab. but when I put the formula in the second sheet it tries to solve itself and gives me zeros. So the pull down tab will end up giving me zeros instead of the formulas. Is what I'm trying to do possible?
@CAMACORP For the most part, the only things to do are to turn of auto calculation on save. If you have a really big workbook with a lot of data, there is little you will be able to do since the new excel format compresses data on saving.
You need to change it back to automatic for that. I know that sometimes it won't be viable to switch back and forth often, but if you want all formulas to update whenever data changes, calculations must be on automatic.
I'm trying to put two formulas in one cell through a pull down tab. but when I put the formula in the second sheet it tries to solve itself and gives me zeros. So the pull down tab will end up giving me zeros instead of the formulas. Is what I'm trying to do possible?
Thanks it saved my time
Thanks for this -- was going mental trying to turn it off.
I'm trying to put two formulas in one cell through a pull down tab. but when I put the formula in the second sheet it tries to solve itself and gives me zeros. So the pull down tab will end up giving me zeros instead of the formulas. Is what I'm trying to do possible?
@CAMACORP For the most part, the only things to do are to turn of auto calculation on save. If you have a really big workbook with a lot of data, there is little you will be able to do since the new excel format compresses data on saving.
I am having a problem with Excel crashing on some pages. Can I get some help?
Thank u. But Farmulas do not wrking after change at manual
You need to change it back to automatic for that. I know that sometimes it won't be viable to switch back and forth often, but if you want all formulas to update whenever data changes, calculations must be on automatic.
Thanks a lot, it saved my lot of time.. great help
Link to VBA code* for auto caulation.
thank you, big help
Tysm man u r gr8 n olso a genius..👍
Thanks!
I've been studying speeding up Macs and discovered a fantastic resource at Achak Speed Plan (check it out on google)
Thanks that solved my S**ty MS excel prob....:)
I'm trying to put two formulas in one cell through a pull down tab. but when I put the formula in the second sheet it tries to solve itself and gives me zeros. So the pull down tab will end up giving me zeros instead of the formulas. Is what I'm trying to do possible?