Z
zfraile
Could someone explain what the deal is with doing a simple paste values in
Excel 2007? I thought it was supposed to be faster, what with using both CPU
cores and all. Instead, the same operation that would take 10 seconds in
2003 on the same machine now goes for 10 minutes before telling me there's
not enough resources?
What I am trying to do is concatenate a string of about 60,000 8 digit
account numbers. Each number is in one row in column A. In column B I have
a formula like ="'" & A1 &"',". In cell C1 I have a formula =B1. In C2
through the end of column C I have a formula =C1 & B2. Then I take the last
cell in column C, copy it and paste as values. I then take that pasted
value, copy it to the clipboard, and use it as the clause for an IN statement
in a SQL query. For some reason, as soon as I get to the paste values part,
Excel 2007 decides to take up 100% of my system resources and then crash.
I'm sure I could find a way around this process, but why should I? It
worked fine before. Also, one other thing, is there any way to make Excel
2007 be a little less greedy with system resources? I used to be able to ask
Excel 2003 to go to work on an intensive calculation and then tab over to
Outlook or Firefox and do something while it worked in the background. Excel
2007 takes over the entire system so all I can do is sit and watch.
This is a 2GHz Core2Duo with 2GB RAM running XP SP2, which was more than
good enough for Excel 2003.
Excel 2007? I thought it was supposed to be faster, what with using both CPU
cores and all. Instead, the same operation that would take 10 seconds in
2003 on the same machine now goes for 10 minutes before telling me there's
not enough resources?
What I am trying to do is concatenate a string of about 60,000 8 digit
account numbers. Each number is in one row in column A. In column B I have
a formula like ="'" & A1 &"',". In cell C1 I have a formula =B1. In C2
through the end of column C I have a formula =C1 & B2. Then I take the last
cell in column C, copy it and paste as values. I then take that pasted
value, copy it to the clipboard, and use it as the clause for an IN statement
in a SQL query. For some reason, as soon as I get to the paste values part,
Excel 2007 decides to take up 100% of my system resources and then crash.
I'm sure I could find a way around this process, but why should I? It
worked fine before. Also, one other thing, is there any way to make Excel
2007 be a little less greedy with system resources? I used to be able to ask
Excel 2003 to go to work on an intensive calculation and then tab over to
Outlook or Firefox and do something while it worked in the background. Excel
2007 takes over the entire system so all I can do is sit and watch.
This is a 2GHz Core2Duo with 2GB RAM running XP SP2, which was more than
good enough for Excel 2003.