Microsoft Office Forums

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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
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
__________________
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
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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:47 AM.


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