Number Format Goes Haywire

kristinh

New Member
Joined
May 3, 2024
Messages
3
Office Version
  1. 365
Platform
  1. Windows
I am working in large Excel files with PivotTables. I am having a recurring issue, typically triggered by refreshing a PivotTable, where my numbers will go haywire. This impacts the cells in the actual PivotTable but also those on other tabs. If I click around and scroll up and down enough, the numbers will go back to normal eventually. I am at a loss to what could be causing this. I am attached a before and after. No number formatting was changed between these screenshots. Only scrolling and moving between tabs.

Correct display:
Good.png


Wacky Display:
Not Good.png
 

Attachments

  • Fixed.png
    Fixed.png
    82.9 KB · Views: 10

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
I have a similar thing happen. Are you using 365 Beta, as I am?

Try doing the Repair procedure in the Windows Apps settings. I found that helped.
 
Upvote 0

Forum statistics

Threads
1,225,739
Messages
6,186,738
Members
453,369
Latest member
juliewar

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