Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'

2. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.


PowerPivot performing another operation

PowerPivot performing another operation (and not allowing you to do anything else)

One of the more frequent error messages we get when using PowerPivot is ‘PowerPivot performing another operation’ and as a result you cannot create a calculated field or import data or do anything with PowerPivot.

Related: Learn how to use PowerPivot

Sometimes this is normal and if you wait a few moments it allows you to continue. However, other times it seems to be stuck in this mode. The easiest way to address this is to close the PowerPivot window (save if you need to). When you reopen the PowerPivot window it should be ready to operate.

Occasionally this also does not work. In this case you need to close the Excel window and re open.