Replies

thanks!

What do you mean by “I have Excel 2007 set to load at startup all files in:
C:Program Files (x86)Microsoft OfficeOffice12XLSTART”?

Under Excel Options/Advanced/”At startup, open all files in” is set to C:Program Files (x86)Microsoft OfficeOffice12XLSTART
Removed the directory entry and it made no difference.

That is the default and not something you need to set up.
You don’t by any chance have 2 personal macro workbooks in separate folders do you?

I have one copy of Personal.xlsb in C:Miscellaneous Dataexcelpersonal excel macro folder in addition to the XLSTART folder.

Thanks for the help!

Nothing disabled

Thanks! I figured setting a whole column as a range was a bad idea.

If I understand correctly COUNTA will work for both text and numbers, whereas COUNT will work for numbers only.

BTW, for those who read this link, this is a good explanation of OFFSET
http://support.microsoft.com/kb/830287

First, thanks for all of the suggestions.

I’m using Outlook 2007, with the same settings on my laptop, home computer, and office computer, i.e., “leave copy on server, remove after 10 days, remove if deleted from deleted items”

It is only when I log on from the hotel that I get all of the duplicates. For now, I’ve unchecked the “leave on server” option and will just forward the important emails when I get back to the office.

works.
thanks!!

my files have been written to cd, therefore for a typical *.xls file I get in Windows Explorer:

Date Modified = 1/25/2011 5:45 PM
Date Last Saved = 8/7/2009 3:07 PM

Date Created = 1/25/2011 5:45 PM
Content Created = 8/7/2009 12:32 PM

Love the program, been using it for years. However, it does not include “Contents Created” or “Date Last Saved” as File Info descriptor.

thanks for the help!

Steve:

Works.
Thanks for the brain unlock!

John

thanks for the reference

thank you both

It gets “cursiouser”. If I turn off multi-threading, the original spreadsheet runs ‘Rank and Percentile’ calculation in 2:30 and the test spreadsheet ‘Rank and Percentile’ calculation in 5:15. No speed demon, but still faster than with multi-threading turned on.

Any suggestions on testing multi-threading or CPU?
Thanks.

thanks.

Question: could it be a question of multi-threaded calculations? Did your Excel run a multi-thread? How does one tell if Excel is running in multi-thread mode?

I’ve done some more testing using attached spreadsheet. Same Computer, a number set generated using rand() and then copied and paste special/value.

Rank and Percentile Calculation

In Excel 2007
No. Points//Calculation Time (min:sec)
10//0:08
50//0:32
100//1:03
500//5:10
1000//10:26

In Excel 2003
No. Points//Calculation Time
10//0:01
50//0:01
100//0:01
500//0:01
1000//0:02

I also tried the original spreadsheet in another computer with win7/excel 2007 and it took anywhere from 1.5 hrs to 3 hrs to calculate a rank and percentile of 5114 numbers, depending on what else the computer was doing at the time. The 1.5 hrs was with nothing else active.

Is anyone else having these types of calculation times?

Right now my workaround is to save file/open in 2003, run rank and percentile/save file/reopen in 2007.

Thanks for the help