Blog & Excel Tips

If you have updated the data of a Pivot Table and it is not being pulled through there are a number of possible reasons. Here we go through them in order of likelihood.

Excel logo nearly at the right shade of green.

The UK government is telling people to stop using Excel spreadsheets because of multiple data breaches

How to drag down a date in Excel without it changing- so the same date must be in all the copied down cells.

How to copy an Excel sheet that is protected, where you are not able to click on the protected cells, only the unprotected cells.

How to use the new Navigation button in Excel to easily see and jump between sheets and elements (tables, charts, PivotTables, and images) in big Excel spreadsheets.

Excel's Edit Links tool has changed. Learn how it works and see some of the great new buttons available to control links to other spreadsheets.

When you use the average function in Excel, it is important to decide what you want to do with zeros. Should they be considered in the average i.e. they are part of the calculation or should they be ignored i.e. the item is there but you want Excel to determine an average without taking that item into account.