Exaggerated File Size

[Guest]

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.

 

[Gord Dibben]

Narvaez

Ususally a result of Excel thinking the Used Range on a sheet(s) is larger
than it really is.

See Debra Dalgleish's site for info on how to reduce.

http://www.contextures.on.ca/xlfaqApp.html#Unused

Gord Dibben Excel MVP

 

[Norman Harker]

Hi Narvaez!

Most probable cause is that Excel thinks the Used Range on a sheet(s)
is larger than it really is.

See:
Debra Dalgleish:
http://www.contextures.on.ca/xlfaqApp.html#Unused

Provides both manual and VBA approaches to correction.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[David McRitchie]

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

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.