PowerPivot Table freezes up after changing measure attribute from Currency to decimal

RSteinke

New Member
Joined
Feb 22, 2012
Messages
6
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Version 2012 PowerPivot RC0 64 Bit using office 2010 on a Windows 7 HP laptop.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
Connecting to MS SQL Server file – Selecting 7 dimensions and 4 measures filtered on date<o:p></o:p>
After saving, the data is brought into the PowerPivot table. The measures are defined as numeric in the SQL file. They are displayed as currency in the PowerPivot table. If I do not make any changes to the powerpivot table such as changing the measures to decimal values, the refresh option works returning 37,216 records in just seconds. As soon as I change the Measure attribute to decimal using the format tool in the PowerPivot ribbon I can no longer refresh the PowerPivot table. The Data Refresh process just sits and spins until I cancel the job. If I try to change the attribute back to currency, the PivotTable locks up.<o:p></o:p>
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Hi there. I have not seen this myself, but with V2 (2012) final version now released, does this still happen for you?
 
Upvote 0
downloaded the current version RTM and it works fine now. Thanks
 
Upvote 0

Forum statistics

Threads
1,223,248
Messages
6,171,027
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top