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 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:

On Friday, January 29, 2010 6:13 AM
Laszlo Gombos wrote:

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/tutorials...ne-part-4.aspx

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:

On Friday, January 29, 2010 6:13 AM
Laszlo Gombos wrote:

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

On Friday, May 21, 2010 11:19 AM
Leland Falde wrote:

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/tutorials...ming-in-c.aspx

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:

On Friday, January 29, 2010 6:13 AM
Laszlo Gombos wrote:

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

On Friday, May 21, 2010 11:19 AM
Leland Falde wrote:

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

On Friday, May 21, 2010 11:22 AM
Leland Falde wrote:

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/tutorials...essing-in.aspx

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:

On Friday, January 29, 2010 6:13 AM
Laszlo Gombos wrote:

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

On Friday, May 21, 2010 11:19 AM
Leland Falde wrote:

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

On Friday, May 21, 2010 11:22 AM
Leland Falde wrote:

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...

On Friday, May 21, 2010 11:22 AM
Leland Falde wrote:

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/tutorials...ses-avail.aspx

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

"Leland Falde" wrote:

> 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 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:
>
> On Friday, January 29, 2010 6:13 AM
> Laszlo Gombos wrote:
>
> 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
>
> On Friday, May 21, 2010 11:19 AM
> Leland Falde wrote:
>
> 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/tutorials...ming-in-c.aspx
> .
>