Forum

OK - after a bit of digging around, it looks as though this can't be done. Just to recap, I want to use VBA programmatically to set whether or not a ...

Hi Catalin, Thanks again. Unfortunately this whole thing started with it looking as though Excel for Mac VBA doesn't support statements like Th...

Hi Catalin, Sorry for the delay in coming back; thanks for taking the trouble to respond and confirming that RefreshAll doesn't take parameters, w...

... I should add that I had also thought about adding some VBA to convert the parameter values to lowercase in the Parameter table and then adding a t...

Hi Phil, Fantastic - very many thanks. It was probably trivial to you but it opened my eyes to more opportunities. I really look forward to the c...

Hi Mynda, Many thanks and I've taken everything in. To be honest, although it seems that we were going round in circles (and we probably were) I w...

Hi Mynda, First a huge apology for upsetting you and I recognize that some of my questions seem contradictory – and sometimes just wrong. I really...

Hi Mynda, Don't know what was going on in my head to get Fact and Dimension tables 180 degrees wrong! I've given myself a stern talking to and hav...

Hi Mynda, I've been doing quite a lot of thinking about this and I'm really grateful for your insights and suggestions. I reproduced the pivot tha...

Hi Mynda, I completely take your point about the table structures - my reason for the Alloc[ation] table was that it is sometimes necessary to swit...

Hi Mynda, Apologies and thanks for your patience. Here it is, I hope. Pieter

Hi Mynda, I followed your advice and learned a lot in the process. I've re-worked my data into normalised related dimension and fact tables (I thi...