top of page

[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 Posts

See All

Improving Excel with Python (May 2022)

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

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page