View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Flanagan Bob Flanagan is offline
external usenet poster
 
Posts: 340
Default Excel 2007 Severe Performance Problems

Norm, would you mind sending me a copy? I have tried to duplicate the
problem with my own data, but have been unable to do so.

Bob Flanagan email: robertflanagan @ add-ins.com

Thanks,

Bob

"NormD" wrote in message
...
Nick, I just posted this but it seems to alpply to this thread so I'm
putting
it here for your comments (and, ideally, sugestions):

Someone wanted specifics, so here is a specific, reproduceable case.

I loaded 6 CSV files each with 7,200 records of time and sound level data
(I'm an acoustical engineer) into individual sheets in one workbook. I've
done this for years with 2003.

Drawing a line chart with three of these sets plotted against a common
time
scale, dragging the graph around, etc. is significantly slower in 2007
than
2003.

I copied the graph from one sheet to another to edit it to refer to the
other three sets of data. When I click on one of the graphs to select the
series, 2007 sits, and sits, and sits...minutes go by. Task Manager
reports
"not responding."

I saved the sheet as an XLS file and loaded into Excel 2003. Near
instantanioous response. Same moodel machines, both running XP. Also
tried
on a MUCH faster dual core machine, with no obvious improvement; app still
sits and sits.

If someone from MS wants to look at the files I'll be glad to send them.

At this point 2007 is nearly unusable for me.

"Nick Hodge" wrote:

You'll need to narrow down your scope to specific issues as it could be
many
and different for each one

For slow calc'ing try turning off multi-threading calculation under
Office
ButtonExcel OptionsAdvancedFormulas

Also for speed the xlsb file format is optimised but there will be
drawbacks
such as larger files, no access to xml components to back-end systems,
etc.

Post back with other specifics if necessary

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

"jkmelancon" wrote in message
...
When running various workbooks that ran without incident as Excel 2003
applications I am experiencing slow-downs and lack of "resource" halts
running the same workbooks now saved as Excel 2007 applications.

These are moderate to small excel applications by corporate standards,
with
just simple sort macros, and they are running on a strong workstation,
under
Vista Ultimate.

The problem is severe. I basically cannot effectively run day to day
required spreadsheets. Anyone have any ideas?-
J. Melancon