Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 03:11 AM.


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