Thanks for the update and confirming you received them. Contact me directly
if you have questions; you have my e-mail with the files I sent.

"Wei Lu [MSFT]" wrote:

Hello Mach,

I received your email and currently I involved our Excel enginner to help
me to isolate this issue. I appreciate your patience.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Dear NormD and Wei Lu:

Has there been a solution to this? I have a similar problem which a 26
column by 700 row sheet. Seems to be a problem with the graphing system.

"NormD" wrote:

Thanks for the update and confirming you received them. Contact me directly
if you have questions; you have my e-mail with the files I sent.

"Wei Lu [MSFT]" wrote:

Hello Mach,

I received your email and currently I involved our Excel enginner to help
me to isolate this issue. I appreciate your patience.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hello ram,

This issue is still under investigation.

I will update if any progress.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

To be quite honest, I'd really like to hear something more than "We'll get
back to you if there's any progress."

I don't expect an instant solution. But has the probelm been duplicated?
Anyone even looked at it yet? What's going on? There are a host of reports
in this newsgroup about this basic problem. Clearly something is going on.

Right now, except for the most basic spreadsheets, Excel 2007 is useless it
is so slow. A flagship MS product deserves more than this.

"Wei Lu [MSFT]" wrote:

Hello ram,

This issue is still under investigation.

I will update if any progress.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Dear Wei,

Thanks for the response. I was wondering if you have been able to confirm
Norm's problem, i.e. do you see the same "slow" preformance as he reports?

Over the weekend I was at least able to keep my spreadsheet from "crashing".
Not sure exactly what worked but it seemed to be best if I saved the sheet
in 2007 format instead of "compatability mode."

One other thought was interaction of newly installed Excel with virsus
software. I am using MS One Care. At some point with One Care I recall a
message that programs may run slow as it checks all of the program files.

"Wei Lu [MSFT]" wrote:

Hello ram,

This issue is still under investigation.

I will update if any progress.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

I've tried it with both file types; there is no obvious difference between
the two in 2007. The same XLS file that crawls in 2007 flies in 2003. And
that's with the same AV programs. In addition, once the files are loaded
(which isn't the problem) AV is done with its checking as far as I know. The
slowness I'm referring to is just simple things like dragging a graph on the
screen or selecting one series out of three on a graph. It is nearly
instantaneous in 2003, and it crawls or stalls in 2007.

"ram" wrote:

Dear Wei,

Thanks for the response. I was wondering if you have been able to confirm
Norm's problem, i.e. do you see the same "slow" preformance as he reports?

Over the weekend I was at least able to keep my spreadsheet from "crashing".
Not sure exactly what worked but it seemed to be best if I saved the sheet
in 2007 format instead of "compatability mode."

One other thought was interaction of newly installed Excel with virsus
software. I am using MS One Care. At some point with One Care I recall a
message that programs may run slow as it checks all of the program files.

"Wei Lu [MSFT]" wrote:

Hello ram,

This issue is still under investigation.

I will update if any progress.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hello Mach,

We did reproduce the slow performance issue.

As I have mentioned, I did not get the response from internal team. I am
double check with them.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hello Mach,

I have send the request to the product team. Currently, I am waiting for
their response. I appreciate your patience.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

i have recently installed ms excel 2007 mainly because i needed more
columns than only 256 column available in excel 2001. However i found it
tedeouly slow while working with graphs. Even mere selecting a graph by
clicking it takes 15 seconds. Other tasks on graph take much longer
time. will any body pl help?

*** Sent via Developersdex http://www.developersdex.com ***

Although many have mentioned graphs and large worksheet sizes, none of
these are the problem... Speed is an issue for some not very large
worksheets, even without graphing. See my previous comment for a
solution that worked for me... I think you periodically have to copy to
a new worksheet and re-fill the formulas.



*** Sent via Developersdex http://www.developersdex.com ***

Slow Excel 2007 calculation in a workbook and one solution - Bob
Flanagan
06-Jun-07 11:29:10

Problem:

In Excel 2007 an xls workbook takes 2-4 seconds to recalculte whenever a
cell is changed. The workbook works fine in Excel 2003.

No external links
no macros
no range names
File well under 1 meg, with very few formulas - mostly data and sums
No conditional formatting
A few IF formulas, about 10-20
About 30 sum functions
Just one worksheet
Changing to manual recalc did not help
Saving as xlsx did not solve
Copying and pasting cells to a xlsx workbook did not solve
Clearing all formats did not solve
Converting all cells to values did not solve
Copying the worksheet to a new workbook did not solve
Deleting all cells did not solve!!!!
Doing an Edit, Clear All did not solve!!!!!

Solution that worked:
Created a new xlsx workbook
Selected the cells and did a copy, paste special formulas to the new
workbook

Changing cells in the new workbook resulted in no delay.

The above works if there is just one sheet in a workbook. I'm not
certain
how one would solve if there were multiple worksheets. Any thoughts?

Most likely there is some corruption in the XLS workbook, but none that
affects performance in 2003, just in 2007.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel





Slow Excel 2007 calculation in a workbook and one solution - Jim Rech
06-Jun-07 12:06:06

Interesting work, Bob, but I don't buy that, especially the "most
likely"
part.


I doubt "corruption" would survive that, after all, what would the XML
equivalent of corruption be?<g

How about we say we don't know the cause but MS damn sure should!

--
Jim
Slow Excel 2007 calculation in a workbook and one solution - Bob
Flanagan
07-Jun-07 09:44:49

Jim, I agree. After several hours of frustration, I jumped to
conclusions
as to the cause. I'm gong to keep trying to find the cause - after
being
away from the problem for a days, I have some more thoughts on how to
pinpoint the problem.

Bob

http://www.eggheadcafe.com/software/...xcel-2007-calc
ulati.aspx









*** Sent via Developersdex http://www.developersdex.com ***