Forum

Thinking about this a bit more, I wonder if it's a Table feature. Tables are designed to copy formatting and formulas down a column. This is best prac...

I agree it seems like it should, however the fact that it doesn't when it preserves all other formatting suggests to me that maybe cell alignment form...

Hi Michele, In that case, select a range of cells 3 rows high and 5 columns wide, then enter this formula: =INDEX(Table1[[Project]:[Status]],SMA...

It's preserving the alignment if the rows within the table are the same because it's not actually loading anything to Excel because there's nothing to...

Hi Micheal, The problem you are currently having where you have to refresh twice to get the PivotTables to update is caused by loading the data to ...

Hi Michele, You didn't mention what version of Excel you have, so I have assumed you have 365, in which case you can use this formula: =CHOOSERO...

Not sure, Tony as it's difficult to say without seeing the file. It does seem like something is wrong if it can process it in 10 minutes upon opening,...

When Power Query gets new data it also gets the original data again, so in effect it's replacing the data that you've formatted. Not sure why it's not...

Hi Michael, Just to be sure, the query should get the data from the external data workbook and load it directly to Power Pivot/the data model in th...

Hi Michael, A Pivot Chart not connected to a PivotTable because it's coming direct from Power Query or Power Pivot? If so, then you can record a ma...

Technically you should have a date dimension table and in that table you would have your financial year column. You can create this in Power Query or ...

Hi Karen, Welcome to our forum! It sounds like you need a new column in your data for the financial year that classifies each date into the corr...

Hi Claudine, I'm not sure there is because the PDF is effectively just a print out. You'd need to make the visuals big enough that there are no scr...

Hi Michele, Welcome to our forum! You can load the Data table to Power Query and then create two versions of the data, one that excludes DEV and...

Hi Jose, Welcome to our forum! This error is caused by a name being referred to in your query for specific table or column names that are no lon...