Something about the scroll bar
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
|