![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
clipboard error freezes workbook | bkcell | Excel | 4 | 06-18-2017 08:00 PM |
Calculate number of days in a table from a specific date | tstolbert | Word | 2 | 06-25-2016 02:30 PM |
How to add attached excel workbook with hyperlink in the same workbook | lynchbro | Excel Programming | 0 | 02-24-2015 01:29 PM |
Is this possible? - Calculate and Display the date range between 2 specific dates | Premier-UK | Excel | 2 | 08-18-2014 05:43 AM |
![]() |
Sinister | Excel | 4 | 04-08-2014 05:53 PM |