Thanks for this helpful video. I don't understand why all my variables, when altered would work and make the averages alter last night and yet when I now use this Excel file this morning (Mac left on sleep) the variables are not making the slightest difference to any of my average figures anymore? It's like they're disabled?
Perhaps your calculation mode has changed to manual. Push F9 to see if updates. To go back to automatic calculations go to formula ribbon and calculation options and change to automatic.
Wow, thanks so much, that fixed it. No idea why MS would think that's a good idea to turn it to manual. Now for some reason when I double click on the bottom right of a cell to replicate it through 8,800 rows it doesn't work? Wondering can I email you about getting a price to create a Master Excel template for my work? Thanks again.@@Advanced_Excel
Thanks for this helpful video. I don't understand why all my variables, when altered would work and make the averages alter last night and yet when I now use this Excel file this morning (Mac left on sleep) the variables are not making the slightest difference to any of my average figures anymore? It's like they're disabled?
Perhaps your calculation mode has changed to manual. Push F9 to see if updates. To go back to automatic calculations go to formula ribbon and calculation options and change to automatic.
Wow, thanks so much, that fixed it. No idea why MS would think that's a good idea to turn it to manual. Now for some reason when I double click on the bottom right of a cell to replicate it through 8,800 rows it doesn't work? Wondering can I email you about getting a price to create a Master Excel template for my work? Thanks again.@@Advanced_Excel
@@bardbardy5573 sure. Send a mail to info@auditexcel.co.za