View Single Post
 
Old 04-06-2019, 04:27 AM
Chibiberu Chibiberu is offline Mac OS X Office 2016 for Mac
Novice
 
Join Date: May 2014
Location: Japan
Posts: 11
Chibiberu is on a distinguished road
Default Excel always freezes when I try to re-calculate a specific workbook

I have a specific worksheet where I add raw data on a hourly basis and I have various graphics based on those data.
Some columns contains formulas based on the raw data I add. The number of cells with formulas doesn't change. Only the quantity of raw data change every day.
I also use a pivot table...



Calculation is set to "manual".


Today, after I added some lines of data, Excel systematically freezes when I want to recalculate the formulas. Excel always freezes when the following message is displayed in the status bar: "Calculating (Spill Resize Pass 1): nn% (nn between 45% and 60%)

Is there any way to know where the problem is?


I put a link when you can download the file if needed.
(link removed by Moderation)

Last edited by Pecoflyer; 04-06-2019 at 08:19 AM. Reason: Remove link
Reply With Quote