6 votes2 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →Simon Jewell commented
I'd like to add to this list. I agree that CF needs a general overhaul so that it works nicely with Tables.
Tables know about columns and rows but CF doesn't and it should. For example, if you add a new row to a table, the range of cells under the CF duplicates the format, so you end up with loads of duplicate rules that make editing the CF difficult. (Clearly the teams developing these features didn't work together.) It would be good to do a review so that the CF range uses the Table columns as references, in the same way that a power pivot table does for data fields, for example.
12 votes3 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
495 votes248 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
I’m happy to announce that your input has had another direct impact on the product. In this case, a decision has been made to have Power Pivot be available in all Windows editions (“SKUs”) of Excel! This means the Business, Home, Standard, etc.. all of these will have Power Pivot. As your comments have indicated, Power Pivot has moved from targeting a specialized audience to generally useful capability for working with data in spreadsheets. As such, it makes sense to make this as broadly available as possible.
We have started rolling this change out with the April Current Channel updates (Builds 9330 and beyond). I’m also happy to announce that these SKU changes will be reflected on the upcoming 2019 version as well.
Thank you for pushing for this!
ExcelSimon Jewell commented
Thank you Microsoft, that is greatly appreciated. Well done.