Hi Narvaez,
If you look at a worksheet does Ctrl+End point to something far
away from the data, If that is not the problem then the rest of
this post is not the solution to your problem.
Reset All Lastcells in the Active Workbook (#resetall)
Reset Last Used Cell
http://www.mvps.org/dmcritchie/excel/lastcell.htm#resetall
Since you have only one sheet then the manual solution
might not take too long. Say you want cell F75 to
be the last cell. in the Name box to the left of the
formula bar enter G:IV then edit, delete
then into the name box enter 76:65536 then edit, delete
then file, save
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
Narvaez said:
I have a file that is only one sheet, I copied it from a file with macros. The size of this new file is 2.63MB and it has no
formulas, no macros and has only text and format. What can I do to find the source of this exaggerated size? I want to reduce this
size.
