Forum

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...

Hi David, It doesn't like the Parent list being in a Table. If you convert this to regular cells and rename it 'Parent' as you'll lose the name whe...

Hi Lea, Have you tried changing the language settings in Excel via the File tab > Options > Language? Mynda

Hi Conny, Welcome to our forum! It's great to hear you found my tutorial helpful. What you have in your Power Pivot model are 3 fact tables. If ...

Hi Jesus, Thanks for sharing your file. I can see it is not in the correct tabular layout. You need to use Power Query to unpivot the 'h' columns i...

Hi Oscar, Welcome to our forum! Please share your file so we can see what might be causing the problem. Mynda

Hi Jesus, The file didn't get attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the fi...

Hi Oli, No file attached. You need to click 'start upload' after selecting your file, then wait for the grey check mark beside the file size before...

Hi Kevin, Please provide a sample Excel file. It looks like you didn't choose the correct column for the values. Mynda

Hi Esteban, Welcome to our forum! Thanks for sharing your file. Duplicate the query, then filter the third column to keep just the rows that con...