Thanks all. Ashamed I never knew it could be turned off.
I'm simply counting within categories and looking to compare.
Worksheet B is monthly report which I've done stuff like tweeked column order to make it so admin just had to copy and paste data in as a 2 min job instead & added in some pivots that are meaningful in the context of my actual work vs the information senior managers want (Worksheet C)
Worksheet A is future forecasting for the same but now includes comparison to the reporting for reflection, hence needing to pull the data through.
Thanks all. Ashamed I never knew it could be turned off.
I'm simply counting within categories and looking to compare.
Worksheet B is monthly report which I've done stuff like tweeked column order to make it so admin just had to copy and paste data in as a 2 min job instead & added in some pivots that are meaningful in the context of my actual work vs the information senior managers want (Worksheet C)
Worksheet A is future forecasting for the same but now includes comparison to the reporting for reflection, hence needing to pull the data through.