Forum

Hi Maarten, Thanks for sharing the file. The image in your Intro sheet has the dim and fact labels back to front. Looking at your model, the di...

Hi Rajiv, Scope of the workbook means when you reference that name you can do so from any sheet in the workbook without qualifying the sheet the re...

Hi Sai, Welcome to our forum! I wonder if the formulas in the summary sheet are recalculating repeatedly during refresh. Why don't you use a Piv...

Hi Al, Welcome to our forum! If you can upload a sample Excel file we can try to help you with step 2. Please ensure the sample data covers all ...

Hi Leslie, Select cell F3 to the end of the cells containing data and press DELETE. This will fix the spill error. You only enter dynamic array for...

Hi Nawaf, It's not the space on your C drive that Excel uses to process the query etc. it's the RAM available. If you have many other programs runn...

Hi Guy, The layout of your workbook suits data entry, but it will be a nightmare to use it in reporting. You can use Power Query to consolidate the...

Hi Rajiv, You cannot edit the scope once you create the name, sorry. You need to re-create the name from scratch with the scope you want. Mynda

Hi Bruno, Power Query can get data from a web page, but that link downloads a CSV file, it doesn't have the data stored in the web page. You need t...

Have you tried putting that URL into Power Query get data > from web?

Hi Nancy, I can see that you are very new to Power Pivot because that's now how to write a CALCLULATE formula. The best way for us to help you is f...

The Excel file itself should have a URL to download it. The first page is just a gateway to the real URL for the file.

Hi Guy, Welcome to our forum! It's difficult to give specific advice without seeing the file, however the number one rule of data layout is a tabul...

Hi Nawaf, You shouldn't need to apply any special settings, however depending on your data source you may want to turn on 'Fast Data Load' in the Q...

Hi Eric, You can use Power Query to append the data on each worksheet, if they have the same column headers, or merge if the column headers are dif...