looking for savy excel users, 2003 and 2010

[vhelp]

if you ain't savy in excel, please disregard.

i need to resolve an issue that no one seems to be able to do. need someone who has faught the 2003 to 2010 battle, and won !!

being a savy excel 2003 user i can not figure out this big problem. thank you.

[vhelp]

test 1

a. say you have many rows and columns of cells filled in,
   and, lets say that this is a document that someone sent to you,
   but you don't know how far down and to the right your documetn is:
   Q: what is the technique to go to the end (the last cell) of a document, in one step ?

b. now, someone has sent you this document (in test 1, a) however, in looking at it,
   and the actual filesize, you determined that something is wrong.  i see this all the time.
   Q: what is it that is wrong with the document ?
   hint: this would be something that you see a lot in excel documents sent to you.
   (i do, and i fix them all the time)

c. so you have this document, (in test 1, b) and you discovered the problem and know you can fix it.
   assuming you know what it is, 
   Q: what is the technique to fix the document ?

apparently, since moving to office 2010, i get a lot of excel documents, or i create a spreadsheet, usually
with a lot of vlookup or index formulas in them, that when i save the document.........

[Bjs]

Like shooting noodles.

Don't do A (ctrl+end) on received document until B

B = Worksheet compatibility issues ... common, then C next

C = Read B, solve, then goto A

As for the rest no idea, looks like you had to dash off at the end.

Q: Why aren't they using the office compatibility pack ?