Link to home
Start Free TrialLog in
Avatar of Dwight Baer
Dwight BaerFlag for Canada

asked on

Excel 2010 always does "updating cells" before it runs my macro. How can I turn that off?

I have a spreadsheet with about 6000 rows, 200 columns and a lot of buttons with associated macros.
Recently it started to do "updating cells" before it executes a macro.  This takes 15-20 seconds.  How can I turn that functionality off?  Thanks
Avatar of Dwight Baer
Dwight Baer
Flag of Canada image

ASKER

Here is the file.

To replicate:  Go to the "Scriptures" worksheet.  Then click on any of the buttons at the top of the columns, e.g. A, B, C, D etc.

The macro is designed to sort the spreadsheet by that column.  It used to work just fine, but now it takes 15-20 seconds while it does "updating cells".
Scripture-140824-trying-to-fix-the-updat
SOLUTION
Avatar of Ray
Ray
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I think the file name was truncated when I uploaded it previously.

It had been set to "Automatic" calculation.  I tried changing it to "manual" just for fun;  it didn't help.

Here's the file uploaded with a shorter name.
Scripture-140826.xlsm
Any luck downloading that file?  Can you replicate the "updating cells" problem?
ASKER CERTIFIED SOLUTION
Avatar of Zack Barresse
Zack Barresse
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks Zack.

Just got back from vacation.

Since this has been open a long time, and your answer seems very thorough, I'll close this question without studying it carefully for now.  I'll look at it tomorrow in detail.

I really appreciate your help.
Thanks!