To completely clear a cell, you must hit Edit--Clear--All and then save
the file.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"filo666" wrote in message
...
Hi, Because englñish is not my first lenguaje and because of the
difficulty
of the question, please try to understan what I'm asking for.


Ok, go to an exel new worksheet and with the scroll bar go to the cell
A300,
there write something (ex. fdslkgjt) and press enter, then, errase the
cell
A300,
go to the cell A1 and look the scroll bar Small???

I don't know why excel, althought you errase the data, still defining the
cell A300 as a part of the sheet.
This is not important if you see as the excel part, a few KB more for the
file and that's all, but Imagine when you use acces¡¡¡¡¡
the whole 300 records (1 MB aprx) appears in you tables, queries and
reports, and also the queries take much longer to appears; How to tell
excel
that the sheet is just of the writed zone and not of all what excells
thinks
they are

PD. Defining or Errasing from acces the records is not a possibility
because
the sheet is linked and the program doesn't allow to modify the exel
linked
page.

TIA