Paste Data from the Web Into a SS & SS Runs Slow
 

Hello,

I have a spreadsheet into which I copy and paste data from the web.
Because the data has hidden characters, (CHR 0160), I strip these out
so the numbers can be added, subtracted etc. All this works well.
However, the spreadsheet I end up with is very large in terms of KB
and when I do any manipulations such as filter or simply key-in a
number to a blank cell it is VERY slow. I have set the calculation to
manual so this is not the problem. I have tried using trim and no
help. I have copied the data and pasted as values into a new workbook
and it is still slow. Any ideas on what I can do to make the data
"clean" and so the spreadsheet will run faster? It would seem this
would be a small spreadsheet in terms of KB as it only contains data,
no formatting and no calculations.

Thanks
JB

Paste Data from the Web Into a SS & SS Runs Slow
 

Hi
see:
http://www.contextures.com/xlfaqApp.html#Unused

--
Regards
Frank Kabel
Frankfurt, Germany

"JB" schrieb im Newsbeitrag
om...
Hello,

I have a spreadsheet into which I copy and paste data from the web.
Because the data has hidden characters, (CHR 0160), I strip these out
so the numbers can be added, subtracted etc. All this works well.
However, the spreadsheet I end up with is very large in terms of KB
and when I do any manipulations such as filter or simply key-in a
number to a blank cell it is VERY slow. I have set the calculation
to
manual so this is not the problem. I have tried using trim and no
help. I have copied the data and pasted as values into a new
workbook
and it is still slow. Any ideas on what I can do to make the data
"clean" and so the spreadsheet will run faster? It would seem this
would be a small spreadsheet in terms of KB as it only contains data,
no formatting and no calculations.

Thanks
JB