#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
External links are potentially dangerous and often cannot be accessed by all our members. I have deleted your link
Please post your file on the forum if you deem it necessary. Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
I used an external link because the file is too big to be posted on the forum. (6MB when zipped, 16MB if not zipped)
|
|
Similar Threads | ||||
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 |
Browse to a specific sheet in an excel workbook | Sinister | Excel | 4 | 04-08-2014 05:53 PM |