paste special keep odbc link
 

I often use worksheets returning the result of a query, with sometimes a
huge number of rows/cells and formulas. In order to work easily on the
result without having Excel still re-calculating the formulas or
querying the database, I copy/special paste the result into a new
workbook.
There should be no link anymore and the last example I have is a sheet
with +/- 2000 rows, no formulas, no odbc, but which still weights 7 Mo
and needs a anormal delay when browsing from one cell to another ... as
if there still was something else than just my datas !!!!
How can I just have my datas and browse inside my sheet as if there
only was text data ?

Thanks a lot !!!


--
phtrochon
------------------------------------------------------------------------
phtrochon's Profile: http://www.excelforum.com/member.php...o&userid=24830
View this thread: http://www.excelforum.com/showthread...hreadid=384287