Windows 10: Excel Pivot Table Measures Stopped Working

Alex Frazee · Feb 23, 2021

So, I had a Pivot Table with a CONCATENATEX calculated column in an .XLSX workbook.

It was working fine until I added data to the source table in the same sheet and workbook. I add data to tables that are connected to Pivot tables all the time and this has never happened.

After "Refreshing All", I did not see the new data in the Pivot table.

I have tried copying and pasting special the data from that table into a new sheet and a new workbook then recreating the pivot table and that still does not get it to work.

When I check the formula it says that there are no errors and the green check mark shows up. It shows up in the PivotTable fields list. I can drag it into the Values section, but when I do nothing happens. It loads for a split second, but then the calculated column does not show up at all in the Pivot table.

I am assuming that I have some old formulas, references, relationships, or something that are getting in the way. I am not sure though. I have tried looking this up, but to no avail so I am not sure exactly what the issue is because Excel is not saying that there is an issue.

Also, I have deleted the table from the data model and re-inserted it. No luck there either. I have run Windows 10 updates, restarted computer, closed & re-opened with Task Manager, etc.

I am assuming that I will probably have to post the file here, but it is for work so I want to see if anyone has any recommendations or answers before posting it.

Finally, please redirect me to the correct place to post this issue if necessary.

Thank you!

:)

nick appleby · Feb 23, 2021

Pivot table in Excel mobile.

Anybody know if the mobile version of Excel will support pivot table ?

This may sound a silly question but can the mobile Excel application on Windows Phone support Pivot tables ( using data within the workbook as source.) If so ,can you use filters. I've open a very simple workbook created in Excel 2010 with a pivot table
and all it seems to have is a filter option of Top 10, Bottom 10 or all.

Please advise.

I'm testing on my HTC Mozart running Mango.

AS31_AS31 · Feb 23, 2021

Excel Pivot Table & Chart

I have created a pivot table & my filter is 'month'. In my drop down, the months are repeating because they repeat in the data. Is there a way so they don't repeat in my pivot table? For example, in my drop down, I would like to select the month but
only have each month listed once.

Brink · Feb 23, 2021

New feature updates for Power Pivot in Excel 2016

We are pleased to announce new feature updates to Power Pivot for Excel 2016 as part of your Office 365 subscription. These updates include the ability to save a relationship diagram view as a picture and enhancements to the relationship dialog experience. We also fixed a number of important bugs to improve your overall modeling user experience.

Save relationship diagram view as picture

Excel 2016 users can now save the data model diagram view as a high resolution image file that can then be used for sharing, printing or analyzing the data model. To create the image file, in the Power Pivot add-in, click File and then select Save View as Picture.

Enhanced Edit Relationship dialog creates faster and more accurate data relationships

Excel 2016 Power Pivot users can now manually add or edit a table relationship while exploring a sample of the data—up to five rows of data in a selected table. This helps create faster and more accurate relationships without the need to go back and forth to the data view every time you wish to create or edit a table relationship.

We have also added several usability goodies to the Edit Relationship dialog:

Table selection using keyboard navigation—Type the first letter of a table name to move the first column name starting with the selected letter.

Column selection using column navigation—Type the first letter of a column name to move the first column starting with the selected letter. Retype the same letter moves to the next column starting with the selected letter.

Auto column suggestion for same column name in both tables—After selecting the first table and column, on the selection of the second table, if a column with the same name exists, it is auto-selected (works both ways).

Fixes that improve your overall modeling user experience

We made a few fixes that improve your modeling user experience, including:

Power Pivot data model is no longer lost when working with hidden workbooks.

Ability to upgrade an Excel 2010 workbook with a data model to Excel 2016 is now available.

Ability to add a calculated column in Power Pivot, unless it contains a formula, is now available.

For a full list in this customer update, visit Power Pivot and the Analysis Services Engine in Excel 2016 fixes.

For all Excel 2016 users, get the latest customer update by installing the following updates. Note, there are 32- and 64-bit versions of each, so be sure to download the right version:

KB3114374—Office 2016 Excel update from December 8, 2015.

KB3114297—Office 2016 Power Pivot in Excel from December 8, 2015.

Try them yourself!

Try these new improvements and see how they can help you improve your analysis performance. Do you have ideas on other improvements that you’d like to see in Excel? Visit the Excel UserVoice and tell us about them.
Click to expand...

Source: New feature updates for Power Pivot in Excel 2016 - Office Blogs

Windows 10: Excel Pivot Table Measures Stopped Working

Excel Pivot Table Measures Stopped Working

Excel Pivot Table Measures Stopped Working

Excel Pivot Table Measures Stopped Working

Excel Pivot Table Measures Stopped Working - Similar Threads - Excel Pivot Table

Power Pivot

Power Pivot

Power Pivot

Transfer Excel table value?

Pivot table view in Access 2016

Pivot table view in Access 2016

Use Power Pivot data in excel

Microsoft Excel has stopped working

New feature updates for Power Pivot in Excel 2016