Microsoft Office Forums Excel always freezes when I try to re-calculate a specific workbook

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-06-2019, 04:27 AM
Chibiberu Chibiberu is offline Excel always freezes when I try to re-calculate a specific workbook Mac OS X Excel always freezes when I try to re-calculate a specific workbook Office 2016 for Mac
Novice
Excel always freezes when I try to re-calculate a specific workbook
 
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
  #2  
Old 04-06-2019, 08:20 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel always freezes when I try to re-calculate a specific workbook Windows 7 64bit Excel always freezes when I try to re-calculate a specific workbook Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

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
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #3  
Old 04-06-2019, 10:35 PM
Chibiberu Chibiberu is offline Excel always freezes when I try to re-calculate a specific workbook Mac OS X Excel always freezes when I try to re-calculate a specific workbook Office 2016 for Mac
Novice
Excel always freezes when I try to re-calculate a specific workbook
 
Join Date: May 2014
Location: Japan
Posts: 11
Chibiberu is on a distinguished road
Default

I used an external link because the file is too big to be posted on the forum. (6MB when zipped, 16MB if not zipped)
Reply With Quote
Reply

Thread Tools
Display Modes


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
Excel always freezes when I try to re-calculate a specific workbook Browse to a specific sheet in an excel workbook Sinister Excel 4 04-08-2014 05:53 PM


All times are GMT -7. The time now is 05:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft