Calculating: (2 processor(s)):x% message

BrendaW

New Member
Joined
Nov 2, 2010
Messages
7
Hi

I am using Excel 2010 and Windows 7. Whenever I try to open this particular workbook, opening the file is delayed and the message above pops up in the grey toolbar in the bottom right hand of the screen. If I click anywhere in the white workbook space, the 'processing' stops and the file opens. As soon as I try to do anything in the file (eg add a new row of data), the processing message appears again and the file temporarily freezes. Clicking somewhere in the file while the processing message is displayed usually ends the freeze so the file can be edited (but not always, and I can't figure out the difference between when this works and doesn't work).

The file is small (374kb) and simple - I am not a very sophisticated Excel user! There are 10 active sheets and 9 have calculations of some sort - generally SUMIFS and COUNTIFS formulas - which are based on data entered into 1 sheet. The data entry sheet has 1638 rows x 10 columns.

The workbook is used daily and the processing message is relatively new. It is most noticeable / prolonged when a new date is entered in the date column (Column A) of the data entry sheet. It used to be possbile to navigate to Column B by simply using the right arrow on the keyboard, but since the message started appearing, we now have to click to move (or wait for the processing to stop, which is very slow).

The file is stored in a Dropbox folder and accessed by 2 users regularly (not sure if this is at all relevant). The second user has Excel 2007 and Windows Xp.

Any advice as to how I eliminate the processing message as it is really affecting the performance and usability of the file?

Thanks very much
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,323
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
I suspect the problem may be the different versions. When you open it in 2010 after it was saved in 2007, a full recalculation will occur. From what you describe, that should not take too long unless your formulas are quite inefficient.
 

BrendaW

New Member
Joined
Nov 2, 2010
Messages
7
Thanks for the reply. If the problem were the different versions, wouldn't it have been evident right from the beginning when the file was initially created?

Are there any solutions to the different version problem, other than upgrading the second machine to Excel 2010 which is not possible right now?

Also thought I'd mention that the initial time to recalculate when the file is opened in 2010 after it's been saved in 2007 isn't very long. There is still, however, a continuous delay when any attempts are made to edit the file.

Thanks
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,323
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Yes, I would have expected it to be evident form the start, assuming the amount of data and formulas was the same.
Does the problem only appear with 2010? Does it occur if you open Excel in Safe Mode (hold down Ctrl key while starting Excel normally)
 

BrendaW

New Member
Joined
Nov 2, 2010
Messages
7
The amount of data (number of rows in data entry sheet) has grown over time, but not significantly. There are about 130 - 150 entries new each month.

The problem occurs in both versions of Excel, 2010 and 2007.

It also occurs even when you start Excel in safe mode.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,323
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Then I would have to guess that something has been added to the workbook (possibly a volatile formula, or code) that is causing a full recalculation whenever you change anything.
 

BrendaW

New Member
Joined
Nov 2, 2010
Messages
7
Any ideas as to how I find that?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,323
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
No really easy way (unless you want to buy the FastExcel addin or a similar one). You'd have to search for volatile formulas like now, today, offset, indirect and so on.
 

BrendaW

New Member
Joined
Nov 2, 2010
Messages
7
Ok thanks. There definitely aren't any of those formulas so there must be something else that's causing problems. Until I can find what it is, I've switched to manual calculations which will help with daily usage, although saving is still rather slow.

Thanks very much for your time.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,323
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
OK. If you can post the file somewhere, or email it, I can take a quick look to see if there's anything obvious, if you like?
 

Forum statistics

Threads
1,081,747
Messages
5,361,038
Members
400,610
Latest member
ebey

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top