Forum

Hi Anura, Welcome to our forum! Thanks for sharing your file. In this case your column headers are the field names. These don't get converted in...

Hi Steve, Welcome to our forum! Power Query won't be the answer. Please share a sample file containing a subset of your data including a PivotTable...

Hi Lisa, I don't have time for consulting, but I can refer you to a consultant. If you reach out via email website at MyOnlineTrainingHub.com and l...

Hi Lisa, The VacayLookup quasi dimension table is filtering the SampleRoster fact table, therefore the Year field in the PivotTable must come from ...

Hi Morne, Welcome to our forum! I've moved your topic to our 'course members only' Excel Dashboards forum so that I make it a priority to answer. P...

Hi Dave, Welcome to our forum! Please try to upload your Excel file again as it didn't get attached. You need to click 'start upload' after sele...

Hi Bax, You can either use Power Query to combine the 3 tables into one table and load that to Power Pivot, or you can create dimension tables for ...

Hi Johnson, Welcome to our forum. The total is taking the sum of the daily rate x the sum of the working days, rather than the sum of the normal ra...

My guess is the rngTypes named formula is causing the problem, specifically the reference to array CompLog[@] Mynda

Hi Lisa, Welcome to our forum! The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey ...

Hi Jessica, Great to hear you're getting a lot out of the courses You can either format the start of quarter date in Excel to only display the ...

Hi Kevin, Great to hear you found my videos helpful Thanks for sharing your file. If you look at the value in the Rekeningnr column you'll see ...

If that doesn't work, then I'd say the answer is no as I'm not aware of any other language or locale settings in Excel.

Hi Oscar, Thanks for sharing your file. Your dates are not the correct format. They're text and they need to be date serial numbers. You can use th...

Hi Louis, Whether the user entered information is in the current workbook or an external source wouldn't make any difference to the refresh process...