Thanks Catalin - It seesm that slicers could be the problem for me - Some of our main reports have 9 slicers, all of them are actually needed but even...
Well I've finally got around to updating my laptop - 16GB, SSD and 64 bit Excel 2016 but...............no noticiable difference The table I have h...
Thanks Mynda.....This is what I need
Thanks Mynda for the link...............Martin
Hi Mynda! The data is imported in to Power Pivot from an Access database. I'm running 32bit Excel - Our IT team have advised that the 64 bit ver...
Many thanks 🙂
Thanks for the fast reply, but I thought this was for the X axis - Anyway it won't accept 0, the date returns......
Thanks for the tip Mynda..................Martin
Trying with the attachment again!
Hi Mynda! A few points that I forgot to mention: =Calendar[This Year] is based on =MAX(Calendar[YearKey]) and this has the value of 2016 =Ca...