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)