[deprecated]Excel summary as values
The advanced options window allows the user to select whether the summary is created using values or formulas. Selecting ‘values’ can reduce the time taken to initially create the summary, and also reduces the time that Excel takes to recalculate the data if it is changed. For a dynamic summary that changes to reflect the user’s input, this option should be left as default.
Click on the options menu and select ‘Advanced options’ to get started.
Recent PostsSee All
Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo