Copying HTML Data From Website problem
 

In using Excel 2003 from 3 years we simply copied a manifest that contained
customer data from a secure website and pasted it into excel with no problems
at all. Excel automagically layed the data out into columns and we had no
problems.

After installing Excel 2007 on 2 of our 3 computers, we tried doing the same
thing and instead of a normal 5 to 6 second wait to paste the data in 2003
the same thing is over an hour (guessing as we didnt wait over an hour) in
2007.

We then tried just higlighting 3 records and copying and pasting in Excel
2007 and it took 11 minutes to handle the 3 records, on the third machine
which still had Office 2003 the same thing took approx 2 seconds.

Someone has suggested we paste/special text but we lose the formatting of
excel automagically seperating the data into columns. This shouldnt be the
solution to the problem as excel should provide the same functionality when
upgrading not a loss of functionality on something as trivial as cutting and
pasting.

Thanks in advance for any help

Copying HTML Data From Website problem
 

Have tried on a couple of brand new vista/office 2007 pc with a couple of
gigs of ram with same result but older machines running office 2003 still
have no problem

"Smish" wrote:

In using Excel 2003 from 3 years we simply copied a manifest that contained
customer data from a secure website and pasted it into excel with no problems
at all. Excel automagically layed the data out into columns and we had no
problems.

After installing Excel 2007 on 2 of our 3 computers, we tried doing the same
thing and instead of a normal 5 to 6 second wait to paste the data in 2003
the same thing is over an hour (guessing as we didnt wait over an hour) in
2007.

We then tried just higlighting 3 records and copying and pasting in Excel
2007 and it took 11 minutes to handle the 3 records, on the third machine
which still had Office 2003 the same thing took approx 2 seconds.

Someone has suggested we paste/special text but we lose the formatting of
excel automagically seperating the data into columns. This shouldnt be the
solution to the problem as excel should provide the same functionality when
upgrading not a loss of functionality on something as trivial as cutting and
pasting.

Thanks in advance for any help