After insert new column excel hangs with not responding

[Laszlo Gombos]

I have about 300000 rows in my table, with 6 columns.
When I delete one column it is not problem, one second.
But when I want to insert a new column between 3rd and 4th, it creates the
new column(s), but starts calculating for unlimited time and not responding.

I have XP SP3 and Office 2007 SP2 installed.
What is the reason, is there any solution for that symptom?

Thanks,
Laszlo

 

[Leland Falde]

I have the same exact problem...any answers out there?



Laszlo Gombos wrote:

After insert new column excel hangs with not responding
29-Jan-10

I have about 300000 rows in my table, with 6 columns
When I delete one column it is not problem, one second
But when I want to insert a new column between 3rd and 4th, it creates th
new column(s), but starts calculating for unlimited time and not responding

I have XP SP3 and Office 2007 SP2 installed
What is the reason, is there any solution for that symptom

Thanks
Laszlo

Previous Posts In This Thread:

After insert new column excel hangs with not responding
I have about 300000 rows in my table, with 6 columns
When I delete one column it is not problem, one second
But when I want to insert a new column between 3rd and 4th, it creates th
new column(s), but starts calculating for unlimited time and not responding

I have XP SP3 and Office 2007 SP2 installed
What is the reason, is there any solution for that symptom

Thanks
Laszlo


Submitted via EggHeadCafe - Software Developer Portal of Choice
WPF Report Engine, Part 4
http://www.eggheadcafe.com/tutorial...45-8b37cb7f3186/wpf-report-engine-part-4.aspx

 

[Leland Falde]

please help if you know what to check, i haven't learned how to disable all calculations so i can see if that is the issue...thanks for any assistance...



Laszlo Gombos wrote:

After insert new column excel hangs with not responding
29-Jan-10

I have about 300000 rows in my table, with 6 columns
When I delete one column it is not problem, one second
But when I want to insert a new column between 3rd and 4th, it creates th
new column(s), but starts calculating for unlimited time and not responding

I have XP SP3 and Office 2007 SP2 installed
What is the reason, is there any solution for that symptom

Thanks
Laszlo

Previous Posts In This Thread:

After insert new column excel hangs with not responding
I have about 300000 rows in my table, with 6 columns
When I delete one column it is not problem, one second
But when I want to insert a new column between 3rd and 4th, it creates th
new column(s), but starts calculating for unlimited time and not responding

I have XP SP3 and Office 2007 SP2 installed
What is the reason, is there any solution for that symptom

Thanks
Laszlo

i am experiencing the same issue
I have the same exact problem...any answers out there?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Parallel Programming in C# 4.0: A Short Synopsis
http://www.eggheadcafe.com/tutorial...4-b0f20bdc955a/parallel-programming-in-c.aspx

 

[Leland Falde]

same thing here...any update?



Laszlo Gombos wrote:

After insert new column excel hangs with not responding
29-Jan-10

I have about 300000 rows in my table, with 6 columns
When I delete one column it is not problem, one second
But when I want to insert a new column between 3rd and 4th, it creates th
new column(s), but starts calculating for unlimited time and not responding

I have XP SP3 and Office 2007 SP2 installed
What is the reason, is there any solution for that symptom

Thanks
Laszlo

Previous Posts In This Thread:

After insert new column excel hangs with not responding
I have about 300000 rows in my table, with 6 columns
When I delete one column it is not problem, one second
But when I want to insert a new column between 3rd and 4th, it creates th
new column(s), but starts calculating for unlimited time and not responding

I have XP SP3 and Office 2007 SP2 installed
What is the reason, is there any solution for that symptom

Thanks
Laszlo

i am experiencing the same issue
I have the same exact problem...any answers out there?

having the same problem
please help if you know what to check, i haven't learned how to disable all calculations so i can see if that is the issue...thanks for any assistance...


Submitted via EggHeadCafe - Software Developer Portal of Choice
Server Side Processing in ADO.NET/WCF Data Services
http://www.eggheadcafe.com/tutorial...f-4f6f92a76585/server-side-processing-in.aspx

 

[Leland Falde]

same here



Laszlo Gombos wrote:

After insert new column excel hangs with not responding
29-Jan-10

I have about 300000 rows in my table, with 6 columns.
When I delete one column it is not problem, one second.
But when I want to insert a new column between 3rd and 4th, it creates the
new column(s), but starts calculating for unlimited time and not responding.

I have XP SP3 and Office 2007 SP2 installed.
What is the reason, is there any solution for that symptom?

Thanks,
Laszlo

Previous Posts In This Thread:

After insert new column excel hangs with not responding
I have about 300000 rows in my table, with 6 columns.
When I delete one column it is not problem, one second.
But when I want to insert a new column between 3rd and 4th, it creates the
new column(s), but starts calculating for unlimited time and not responding.

I have XP SP3 and Office 2007 SP2 installed.
What is the reason, is there any solution for that symptom?

Thanks,
Laszlo

i am experiencing the same issue
I have the same exact problem...any answers out there?

having the same problem
please help if you know what to check, i haven't learned how to disable all calculations so i can see if that is the issue...thanks for any assistance...

i am experiencing the same issue
same thing here...any update?


Submitted via EggHeadCafe - Software Developer Portal of Choice
Free Online Courses Available for Eggheadcafe.com Users
http://www.eggheadcafe.com/tutorial...8-fc3cf6855293/free-online-courses-avail.aspx

 

[Tom Hutchins]

To set calculation to manual in XL2007, select the Formulas ribbon. In the
Calculation section, there is a dropdown for Calculation Options. Select
Manual.

Hope this helps,

Hutch