Forum Discussion
Manual calculation mode doesn't work for calculated table columns??
When I switch calculation mode to manual, it does not stop formulas in calculated table columns from recalculating. Is this expected? I feel like manual mode used to work for tables, but maybe I'm rem...
Hi,
You can do it with the following rules:
1-Go to the File tab on the Ribbon.
2-Choose Options.
3-Choose Proofing.
4-Click on the AutoCorrect Options button.
5-Choose the AutoFormat As You Type tab (if not already selected).
6-Check the box that says Fill formulas in tables to create calculated columns.
7-Hit OK.
The following link will be useful:
https://www.excelcampus.com/tables/prevent-table-formula-autofill/
