J
JB
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
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