UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Recalculating ...    
 
   
dflak
post Mar 20 2012, 08:11 AM
Post #1

Utter Access VIP
Posts: 3,598
From: North Carolina
Does anyone know why it should take 5 minutes to recalculate when you fitler something? Excel will have to recalcultate the count of records returned which it displays instantly and it *might* have to recalcualte totals on the selected page. It should not affect ANY other calcualtions in the workbook. So why does it take 5 minutes to filter about 250 rows with only NO numeric columns to total?

Turning off calculations does not speed up the filtering process. This has to do not with recalcualting the workbook, but with filtering a single page. Is there any way to tell Excel don't go through all of this until I tell you I am finished with applying all the filters I intend to apply?
Go to the top of the page
 
+
AvgJoe
post Mar 20 2012, 08:59 AM
Post #2

UtterAccess Ruler
Posts: 2,042
From: West Coast, USA
Dan,

Open Control Panel and then Add/Remove Programs. Check to see if the "Microsoft Office Validation Tool" is installed. If it is, uninstalling it will dramatically shorten the recalculating time.


AvgJoe (IMG:style_emoticons/default/hat_tip.gif)
Go to the top of the page
 
+
dflak
post Mar 20 2012, 09:43 AM
Post #3

Utter Access VIP
Posts: 3,598
From: North Carolina
I have Windows 7 and I see a Microsoft Office File Validation Add-in - could this be what you are talking about?
Go to the top of the page
 
+
AvgJoe
post Mar 20 2012, 09:47 AM
Post #4

UtterAccess Ruler
Posts: 2,042
From: West Coast, USA
Dan,

Yes. I believe that's what is giving you the (recalculating) grief.


AvgJoe (IMG:style_emoticons/default/hat_tip.gif)
Go to the top of the page
 
+
dflak
post Mar 20 2012, 10:14 AM
Post #5

Utter Access VIP
Posts: 3,598
From: North Carolina
I will try it out and let you know (IMG:style_emoticons/default/smile.gif)
Go to the top of the page
 
+
AvgJoe
post Mar 21 2012, 08:28 AM
Post #6

UtterAccess Ruler
Posts: 2,042
From: West Coast, USA
Dan,

Any luck?


AvgJoe (IMG:style_emoticons/default/hat_tip.gif)
Go to the top of the page
 
+
dflak
post Mar 21 2012, 11:23 AM
Post #7

Utter Access VIP
Posts: 3,598
From: North Carolina
Haven't had time to try it (IMG:style_emoticons/default/smile.gif)
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th June 2013 - 06:55 PM