Hi,

I am using the Quick Analysis tables in Excel 2013 but do not always get the full options:

Sometimes it gives me the options of 4 Pivot tables plus a More Pivots option, then other times it will only give me 1 Pivot table option and More Pivots. (see attached images)

Can anyone tell me why this is?

Thanks in advance
Caz

Attached Images

	Pivot Table Options.png (7.3 KB, 15 views)
	Pivot Table Options 2.png (5.6 KB, 13 views)